Registered aircraft · 2,915

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:74-08-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2') 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:74-08-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
  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:74-08-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
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.

N801XAWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 61781 N801XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35220 N802DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46076 N802FXFederal Express Corp · Memphis, TNS/N 344 N802MRDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 612 N802NNWilmington Trust Co Trustee · Wilmington, DES/N 31073 N802XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61782 N803DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46123 N803FXFederal Express Corp · Memphis, TNS/N 362 N803MRDepartment Of Homeland Security · Washington, DCBuilt 2006 · S/N 626 N803NNAmerican Airlines Inc · Fort Worth, TXS/N 29566 N803TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27156 N803XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61797 N804DHBjw Services Inc · Kingman, AZS/N 46091 N804FXFederal Express Corp · Memphis, TNS/N 370 N804JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5142 N804MRUS Department Of Homeland Security · Washington, DCS/N 374 N804NANasa Neil A Armstrong Flight Research Center · Edwards, CAFirst renewal noticeBuilt 1982 · S/N 344 N804NNAmerican Airlines Inc · Fort Worth, TXS/N 29567 N804SNAtares Funding LLC · Miami Beach, FLBuilt 2000 · S/N 48804 N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988 N804XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61784 N805FXFederal Express Corp · Memphis, TNS/N 372 N805JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5148 N805MLSmb Md-87 II LLC · Longwood, FLS/N 49777 N805MRUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 655 N805NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31075 N805XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61785 N806FXFederal Express Corp · Memphis, TNS/N 375 N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302 N806NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29561 N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081 N806WA53251 LLC · Miami Springs, FLBuilt 1991 · S/N 53251 N806XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61786 N807EXFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 292 N807FXFederal Express Corp · Memphis, TNS/N 383 N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312 N807MRUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 663 N807NNAmerican Airlines Inc · Fort Worth, TXS/N 31077 N807WAFederal Dynamics Corp · Henderson, NVBuilt 1993 · S/N 53093 N807XAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 63406 N808MRUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 667 N808NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1984 · S/N 424 N808NNWilmington Trust Co Trustee · Wilmington, DES/N 33206 N808WACaribbean Sun Airlines Inc · Miami, FLBuilt 1990 · S/N 53044 N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349 N809NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33519 N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796 N80AUAurora Flight Sciences Corp · Manassas, VABuilt 1998 · S/N 340B437 N8100LDynamic Avlease Inc · Bridgewater, VABuilt 1989 · S/N 146

Back to AD 74-08-09 R2