AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N30280Emery Clint L · Texarkana, ARN302STManagement Support Services LLC · Naturita, CON30374Canihan William R · Novato, CAN303CTFloyd Brian · Eatonton, GAN30444Crapnell Mark · Huntington Beach, CAN30453Lehman Land Management LLC · Vernon, TXN30488Valiair Lc Trustee · Casper, WYN30516J A Sutherland Inc · Ukiah, CAN30530Banegas Jose C Zankiz · Fort Myers, FLN30549Lad Custom Publishing Inc · Buford, GAN30583Roviaro Edward · Schererville, INN30593Valiair Lc Trustee · Casper, WYN305KWPumpkin Eater LLC · Tavares, FLN305PYUfly Vi LLC · St Thomas, VIN30644Registered aircraftN3075YAir Eagle LLC · Rome, GAN30777Huff Charles Christopher · Midland, TXN307CFSchwarzenberg Johannes · Helena, MTFirst renewal noticeN307JHRoundy Joseph · Three Forks, MTN308BCMike Kilo Foxtrot LLC · Wilmington, DEN30942Polar Bear Aviation LLC · Batesville, MSN30EWThree Zero Echo Whisky Inc · Wilmington, DEN30HDRegistered aircraftN30MSFlying Medical Service · Grosse Pointe, MIN30MTMcnamara J Kevin · Cascade, IDN30VGGeoterra Inc · Eugene, ORN311JBJack Brain And Associates Inc · Castro Valley, CAN312SCBarker Family Investments Management Co LLC · Tyler, TXN313GBBurnett Gregory C · Rogersville, MON313MPAlpha Bravo Charlie 1 Corp · Houston, TXN313WTCinotto Robert L · Rhome, TXN3148PSky Hi Aviation LLC · Wilmington, DEN3153BSeverson James A Jr · Tualatin, ORN3156XBack Country Aviation LLC · Jupiter, FLN3160LKo Hee Sun · Norwood, NJN316MLJump N316ml LLC · East Berlin, PAN316RWFour States Tire & Service Inc · Cortez, CON319JFRegistration Pending · Johns Island, SCRegistration pendingN31MDKarmy Paul Edward · Burleson, TXN3210PKilcullen Brian DBA · Fort Lauderdale, FLN321BLWalls Bruce · Middletown, OHN321BPCenturion Air Inc · Ridgewood, NJN321DGAdkison Edy P · Riverside, CAN321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLN321PCStene Aviation Inc · Polson, MTN322LKFindley Air LLC · Temecula, CAN32331Sowers Richard M · Reno, NVN323DASky West Aviation Inc Trustee · Albuquerque, NMN323DCFlymax Aircraft LLC · Ball Ground, GAN3259RGlobal Marc Aire Inc · Dallas, TX
Back to AD 2002-07-01