AD 2000-08-07
Registered aircraft · 369
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:2000-08-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:2000-08-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:2000-08-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:2000-08-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.
N800SEDodson 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, NYN84JGTexas Aircraft Parts Brokers LLC · Seguin, TXN84UPN84up LLC · Wilmington, DEN850DPN850dp LLC · Wilmington, DE
Back to AD 2000-08-07