AD 2000-22-18
Registered aircraft · 914
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-18')
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-18')
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-18') 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-18') 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.
N17979Alford Flying LLC · Wichita, KSN17980Rowles Robert · Pittsfield, ILN17BRJds Management Co LLC · Warner Robins, GAN1807NDouble Barrel Aviation LLC · Fort Valley, GAN1810XAviation Trust Company LLC Trustee · Oklahoma City, OKN18142Aviation Trust Co LLC · Oklahoma City, OKN1817SClear Skies LLC · Stuart, FLN1827LCone James R Jr · Lubbock, TXN18296Star Flight Aviation Inc · Shreveport, LAN1829ECorporate Airtime LLC · Clinton, MSN18320Cox Jack H Jr · Arlington, TXN18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYN18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeN18361Landvater Darryl V · Williston, VTN18364Goeken Peter C · Dakota Dunes, SDN18386Gamco Aviation LLC · Shreveport, LAN18475Gerlach And Associates LLC · Valparaiso, INN1852WDavis Sean · Carlisle, IAN1854RSellers William G III · Troy, ALN185ARortvedt Robert S · Mukwonago, WIN186VBLatb LLC · Lewes, DEN18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILN18752Morgantown Flying Club LLC · Morgantown, WVN1889WSabre 65 LLC · Helena, MTN1895LPalm Group LLC · Metairie, LAN18HMYoung Craig · Ada, MIN18VRVentura Air LLC · Wilmington, DEN1901LBerry Darrel · Camden, TNN190RSBas Part Sales LLC · Greeley, CON191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLN198BArkla Aviation LLC · Farmerville, LAN1MFWise Christopher J · Plano, TXN1MQGc4 Aero LLC · Birmingham, ALN2021UAll Airline Pilot Training LLC · Delray Beach, FLN2022TAero-Marine LLC · Miramar Beach, FLN2023CFulps Aviation LLC · Winston Salem, NCN2026WGta Air Inc · Addison, TXN2027DNichols Neil A · Aalachicola, FLN2027UJpb Diversified LLC · Auburndale, FLN20292Laflight LLC · Goldsboro, NCN202PSc Infinities LLC · Dover, DEN2043ACampion Richard · Tampa, FLN204GAirmart Inc · Lexington, KYN2059XK Wings LLC · Golden Valley, MNN205AGWing Men LLC · Cleveland, OHN205KTMha Interests LLC · Spring, TXN2063GHolman Allen S · Knoxville, TNN2064VGta Air Inc · Addison, TXN2070LBaron 70 Lima LLC · Modesto, CAN207ZMInternational Air Services Inc Trustee · Carson City, NV
Back to AD 2000-22-18