Registered aircraft · 1,000

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-03-17-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-03-17-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-03-17-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-03-17-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-03-17-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-03-17-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.

N101GQBankruptcy Services LLC · Wilmington, DEBuilt 2018 · S/N 1262 N101MDHolt Aviation LLC · Clear Lake, IABuilt 2015 · S/N 1085 N1024SAether Aircraft LLC · Roseville, MNBuilt 2011 · S/N 586 N103JDCentaur Aviation Co LLC · Spring, TXBuilt 2012 · S/N 619 N105TMJetnexa Twelve LLC · Gilbert, AZBuilt 2021 · S/N 1383 N108CRCambridge Investment Group Inc · Fairfield, IABuilt 2006 · S/N 347 N10VWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 1454 N110RPCalamigo Management Company LLC · Santa Barbara, CABuilt 2023 · S/N 1504 N111RFEaston Air LLC · Middletown, RIBuilt 2003 · S/N 259 N114YMValiair Lc Trustee · Casper, WYS/N 514 N115WFFlawless One LLC · Atlanta, GABuilt 2022 · S/N 1425 N117MVBtc Aviation LLC · Rehoboth Beach, DEBuilt 2021 · S/N 1388 N118RLS&S Aviation Inc DBA · Cameron, WIS/N 1200 N11LM11lm Aviation LLC · Saint Petersburg, FLBuilt 2023 · S/N 1507 N11MABank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 1232 N11TCarlisle Capital Corp · Portsmouth, NHBuilt 2025 · S/N 1609 N11VUTurboair LLC · Akron, OHBuilt 2017 · S/N 1160 N11YDSpeed Bird LLC · Cincinnati, OHBuilt 2009 · S/N 500 N121HBHallick Air Services LLC · Madison, WIBuilt 2014 · S/N 1016 N123ZCJasper Industries Ltd · Mokena, ILBuilt 2002 · S/N 229 N124ALTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 1606 N1253CEleven1 LLC · Los Altos, CABuilt 2022 · S/N 1444 N128BJTransatlantic Deliveries Trust · Wilmington, DES/N 1671 N128WFJla Equipment LLC · New York, NYBuilt 2015 · S/N 1093 N12MAForest Hill Management LLC · Forest Hill, MDBuilt 2005 · S/N 318 N130TMBurton Equity Management LLC · Arlington, VABuilt 2021 · S/N 1385 N132Savauge Tbm LLC · North Las Vegas, NVS/N 1522 N138JMFull Throttle Aviation LLC · Clayton, DEBuilt 1991 · S/N 7 N138MAMainstream Aviation II LLC · Benton, KYBuilt 2012 · S/N 613 N1421ZMng Leasing LLC · Bottineau, NDBuilt 1998 · S/N 140 N144JTFlight 1976 LLC · Kennesaw, GABuilt 1999 · S/N 144 N145RKFowler Aviation LLC · Union, NJBuilt 2016 · S/N 1142 N148UMUnverferth Manufacturing Co Inc · Kalida, OHBuilt 2004 · S/N 297 N14NXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 1588 N14SCSouth Central Aviation LLC · Evansville, INBuilt 2011 · S/N 589 N1569CN1569c Inc Trustee · Wilmington, DEBuilt 2024 · S/N 1540 N15NMNorthern Valley Air Ltd LLC · Long Island, KSBuilt 2008 · S/N 458 N15SBHgx Aviation LLC · West Chester, PABuilt 2021 · S/N 1405 N160RMLjwms Partners Inc Trustee · Wilmington, DEBuilt 1992 · S/N 63 N160TMTbm N160tm LLC · Fresno, CABuilt 2021 · S/N 1394 N168CWXu Zhaohui Executor · Memphis, TNS/N 30 N171MVLittmarck Svante · Dedham, MABuilt 2024 · S/N 1572 N173TMEllegeegee Corp · Northampton, MABuilt 2010 · S/N 533 N175JCSacramento County Sheriffs Office · Mather, CABuilt 2015 · S/N 1099 N175KCKinzler Aviation LLC · Ankeny, IABuilt 2024 · S/N 1542 N179NCSky Works LLC · Camarillo, CABuilt 2014 · S/N 1044 N17YGTbmyan Inc Trustee · Wilmington, DEBuilt 2025 · S/N 1602 N180MFPapa Sierra Holdings LLC · Dover, DEBuilt 2000 · S/N 172 N183TBBluesky Tb Corp Trustee · Wilmington, DEBuilt 1992 · S/N 3 N183WPLj Horizon Ventures LLC · Fort Worth, TXBuilt 2017 · S/N 1213

Back to AD 2007-03-17 R1