Registered aircraft · 108,433

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2449QAcme Aircraft Co III LLC · Arvada, COBuilt 1966 · S/N 18257649 N2449TElevation Club Air LLC · Hunting Valley, OHBuilt 2005 · S/N 18281727 N244AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881734 N244AKRuckman Jim D Jr · Clarksville, TNBuilt 1982 · S/N 18-8209016 N244ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496043 N244AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13224 N244BHHelicopter Holdings LLC · East Falmouth, MABuilt 2016 · S/N 2449 N244BJJapundza Bob · Kokomo, INBuilt 2000 · S/N 22977 N244BMCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1974 · S/N 28-7415157 N244CCThompson Helicopters LLC · Uvalde, TXS/N 0860 N244CGEagle Sport Aviation Club Inc · De Leon Springs, FLBuilt 1968 · S/N 25-4734 N244CRChiponna Ranch LLC · Surprise, AZBuilt 2023 · S/N 14642 N244CSAerial Expert Enterprise LLC · Plainview, MNBuilt 2012 · S/N 13374 N244CZBradley Tyson A · Abilene, TXBuilt 2000 · S/N 0244 N244DAPrairie Winds Aviation LLC · Overland Park, KSBuilt 1972 · S/N 17261294 N244DBAnsari Ramin · West Lafayette, INBuilt 1976 · S/N 18265043 N244DDTech Central LLC · Southport, NCBuilt 2014 · S/N E-4044 N244DKTiki Helicopters LLC · Riviera Beach, FLBuilt 2004 · S/N 10529 N244DRG H Enterprises Inc · Baton Rouge, LABuilt 1972 · S/N 28-7305018 N244DWInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 0001 N244EBanyan Aircraft Sales LLC · Fort Lauderdale, FLBuilt 2008 · S/N TH-2226 N244EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13283 N244ERKeith Bryan P · Los Angeles, CABuilt 1992 · S/N 10123 N244FRSmith Larry · Ulysses, KSBuilt 1978 · S/N 17270490 N244GObrien Michael Timothy · Corpus Christi, TXBuilt 1999 · S/N 01 N244GGR44 Aircraft Leasing LLC · Tampa, FLBuilt 2023 · S/N 14613 N244GHJakes Air Services LLC · Holt, FLS/N 0833 N244HEDubin David A · Tucson, AZS/N 21058990 N244JALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 2021 · S/N 28020024 N244JBSpier Ronald B · Springfield, OHBuilt 1999 · S/N 0560 N244JHDecca Aviation Operations Inc · Lincoln, NEBuilt 1976 · S/N E-818 N244JNShepherd Jacob · Lake Havasu City, AZBuilt 1964 · S/N D-7698 N244KSSnodgrass Charles Kenneth · Boise, IDBuilt 2022 · S/N 30085 N244MBMunoz Santiago J · Kimberton, PABuilt 2005 · S/N 1426 N244MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881709 N244MKRegistered aircraftBuilt 2001 · S/N 1017 N244MMNovember Alpha LLC DBA · Dover, DES/N 10724 N244NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842054 N244PKTexas Specialty Hunts Inc · San Angelo, TXBuilt 2024 · S/N 14775 N244RAMd Ag Services LLC · Sterling City, TXBuilt 2005 · S/N 10662 N244RFBanovetz Mark T · Naperville, ILS/N FM96-59-01096 N244RHRobinson Helicopter Co · Torrance, CABuilt 2021 · S/N 30080 N244RLSouthern Maine Helicopter LLC · Sanford, MEBuilt 2013 · S/N 2333 N244RPMitchell N Andrew · Bridgeport, CTBuilt 1973 · S/N 182-62311 N244RVSalcedo Daniel Richard · Fort Lauderdale, FLS/N 1242 N244SCGiacometto John · Stevensville, MTBuilt 2004 · S/N 42047 N244SDPerazzo Enterprises Inc · Brookeland, TXS/N 28-7125536 N244SFKitsune Air LLC · Wilmington, DEBuilt 2005 · S/N 40.558 N244SLTpc Inc · Childress, TXBuilt 2004 · S/N 10493 N244SPToth Douglas F · Scottsdale, AZBuilt 1963 · S/N 205-0379

Back to AD 2007-04-19 R1