Registered aircraft · 999

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.

N544MDMbt Administration LLC · Alpine, WYBuilt 2016 · S/N 1111 N545WBLamy LLC · Alexandria, LABuilt 1996 · S/N 107 N54EC400 Knot Aviation LLC · Granbury, TXBuilt 2013 · S/N 665 N551MATwo Fives LLC · San Diego, CABuilt 2009 · S/N 516 N555HP8992 Air LLC · Whitman, NEBuilt 2015 · S/N 1060 N555TQSpats Aviation LLC · Toledo, OHS/N 555 N559CASky West Aviation Inc Trustee · Albuquerque, NMS/N 213 N55DGReynolds Tbm Group LLC · Dover, DEBuilt 2020 · S/N 1340 N55LYHely Fly Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1215 N55XN55x LLC · Missoula, MTBuilt 2021 · S/N 1379 N561TBPembrook Aviation LLC · Los Angeles, CABuilt 1993 · S/N 90 N562AWElbon John W III Trustee · Sedalia, COBuilt 2017 · S/N 1203 N564DD115 Holdings LLC · Mansura, LABuilt 2019 · S/N 1292 N565CVJag Capital Holdings LLC · Winnetka, ILBuilt 2010 · S/N 565 N566FFMidwest Ethanol Transport LLC · Granite Falls, MNBuilt 2022 · S/N 1413 N56AJAj5 Granite Legacy LLC · Arroyo Grande, CABuilt 2019 · S/N 1280 N56WFCatterall Nigel Grant · Sugar Land, TXBuilt 1991 · S/N 8 N576MAMeru Aviation LLC · Gibson City, ILBuilt 2010 · S/N 545 N579MPShaw Aircraft LLC · Grand Junction, COBuilt 2024 · S/N 1556 N579NKontek Industries Inc · Kannapolis, NCBuilt 2007 · S/N 388 N57ASTtx Air LLC · Sturgeon Bay, WIBuilt 2024 · S/N 1535 N57LDHinckley Montana LLC · Reno, NVBuilt 2016 · S/N 1130 N57MGMd Graham & Associates · Visalia, CABuilt 2024 · S/N 1570 N580MABigskytoabaco LLC · Helena, MTBuilt 2011 · S/N 606 N581MD21 Full Send Aviation LLC · Waukee, IABuilt 2011 · S/N 581 N585GCD&G Aviation LLC · Denver, COBuilt 2014 · S/N 1015 N585NJEagle Helicopters Inc · Spokane, WABuilt 2023 · S/N 1511 N590JLVincent Valuations LLC · Merry Hill, NCBuilt 2004 · S/N 306 N595KTColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2020 · S/N 1348 N598WFService Providers Leasing · Batesville, INBuilt 2022 · S/N 1442 N599GBuford John B · Memphis, TNBuilt 2008 · S/N 491 N59AAContendair LLC · Homestead, FLBuilt 2018 · S/N 1234 N59PVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2015 · S/N 1089 N59XTBlue Sky Operations LLC · Carmi, ILBuilt 2014 · S/N 1023 N5HTHigh Calling LLC · Golden, COS/N 9 N5JRBreckenridge Aviation LLC · Fort Smith, ARBuilt 2009 · S/N 512 N5KCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 1207 N5KPDa King Aviation LLC · Miami, FLBuilt 2018 · S/N 1231 N5NXDiversified Control Inc · Orchard Park, NYBuilt 2024 · S/N 1531 N5UMDml Aviation LLC · Ann Arbor, MIBuilt 2019 · S/N 1307 N601AC20th Century Homes Inc · Hopkinton, MABuilt 2009 · S/N 530 N607JMDelta Aviation LLC · Lamoni, IABuilt 2007 · S/N 401 N615TXHappybay LLC · Traverse City, MIBuilt 2014 · S/N 1047 N616CMEirecorp Corporate Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 540 N61JTThorpe James R Trustee · Naples, FLBuilt 2023 · S/N 1517 N61SWFlight Contract Services Inc · Las Vegas, NVBuilt 2011 · S/N 560 N621KSSadler Kevin Marshall · Santa Fe, NMBuilt 2025 · S/N 1599 N621LAPluto Aviation LLC · Sheridan, WYBuilt 2024 · S/N 1538 N622MAMarkle Aviation LLC · Wilmington, DEBuilt 2013 · S/N 681 N625FSAg Solutions Group Intermediate Corp · Chickasha, OKBuilt 1999 · S/N 154

Back to AD 2007-03-17 R1