AD 2000-22-03
Registered aircraft · 425
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-22-03')
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-22-03')
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-22-03') 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-22-03') 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.
N800WAKmwflight LLC · Wilmington, DEN800WDV1vr 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, TNN810KBOrange Skies LLC · New Carrollton, MDN812LLH800 Vi LLC · Stuart, FLN812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN816JMFoxfire Aviation LLC · Henderson, NVN816KYBcp 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, DEN83MDFielding William · Delray Beach, FLN847TX4 Ms Holding LLC · Spring, TXN848NAsf Aviation LLC · Cortlandt Manor, NYN84JGTexas Aircraft Parts Brokers LLC · Seguin, TXN84UPN84up LLC · Wilmington, DEN850DPN850dp LLC · Wilmington, DEN850FBBocre Leasing Inc · Hauppauge, NYN850SXN850sx LLC · Lewes, DEN850UXHawker Jet Holdings LLC · Opa Locka, FL
Back to AD 2000-22-03