AD 2003-07-07
Registered aircraft · 373
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
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:2003-07-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-07-07')
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:2003-07-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-07-07') 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.
N800PEFour C Air Inc · Delano, CAN800PLN800pl LLC · Fort Lauderdale, FLN800RGRm13 Air LLC · Wellington, FLN800SEDodson International Parts Inc · Rantoul, KSN800SVAircraft Fidelity Corp Trustee · Dover, DEN800THHoover Aviation LLC · Nashville, TNN800TLN800tl LLC · Wilmington, DEN800UKJ W Construction Co Inc · Wise, VAN800UWUniform Whiskey Holdings LLC · Opa Locka, FLN800VRCkv Express LLC · Minneapolis, MNN800WAKmwflight LLC · Wilmington, DEN800WFVarsity Aviation LLC · Martinsburg, PAN800WHGsmh LLC · Daniel Island, SCN800WWPnw Transport LLC · Tucson, AZN800XMFlyteme Aviation LLC · Fort Pierce, FLN800XRSparks Aviation Ownership LLC · Santa Rosa Beach, FLN801LMGlobal Aircraft Solutions LLC Trustee · San Antonio, TXN801PJGovoa LLC · Miami Beach, FLN801RMBlue Skies Hawker LLC · Canton, MIN802CFLitton Global LLC · Wilmington, DEN802WJXoom Enterprises LLC · Sunny Isles Beach, FLN803RKAircraft Holding Solutions LLC Trustee · Newark, DEN804BHMahaska Bottling Co · Oskaloosa, IAN804JMStarr Aviation Solutions LLC · New York, NYN804MC824 Holdco LLC · Salt Lake City, UTN804TBN804tb III LLC · Stuart, FLN806GJPb Air LLC · Higley, AZN806MNJm Soar LLC · Paradise Valley, AZN806TCAviation Resource Group Inc · Fort Lauderdale, FLN807AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN808MCLrt Aero Partners LLC · Sheridan, WYN80PKN80080pk LLC · Stuart, FLN810AFJt Acquisitions LLC · Nashville, TNN812LLH800 Vi LLC · Stuart, FLN812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN816KYBcp Fa Ap LLC · Providence, RIN816LXEa Enterprises LLC · Bismarck, NDN817SDSea Aviation Holdings LLC · Wilmington, DEN818LXN818lx LLC · Wilmington, DEN821LBTvpx Ars Inc Trustee · Concord, MAN821MPLucas Aviation LLC · Fremont, MIN822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN823AMAirmed International LLC · Birmingham, ALN825QTKjm Air LLC · Aurora, ILN826GCMqe LLC · Missoula, MTN82RSFly Mda Aviation LLC · Opa Locka, FLN831LXM&N Equipment LLC · Englewood, CON838BBE D Santos & Associates LLC · Wilmington, DEN847TX4 Ms Holding LLC · Spring, TXN848NAsf Aviation LLC · Cortlandt Manor, NY
Back to AD 2003-07-07