AD 2002-12-07
Registered aircraft · 63,519
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-12-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:2002-12-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:2002-12-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:2002-12-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.
N1046XFarnham Aviation Services LLC · Ames, IAN10470Leary Dan P · Girdwood, AKN10475Lissow William M · New Port Richey, FLN1047JFirst Flight Investments LLC · Bartow, FLN1047NMccormick William R · Louisville, KYN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1047YDonato Deleonardis · Paulden, AZN10480Piper 66 LLC · Kirksville, MON1048AUnderdahl Kirby L · Hamilton, MTN1048DDumbravo Dustin C · Yorktown, VAN1048EPaul John R · Boise, IDN1048FWard Anthony · Paige, TXN1048LSparrow Thomas E · Hawley, MNN1048QTaf Aerial Services LLC · Corpus Christi, TXN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049JLoxley Jason C · Virginia, ILN1049PLamal Thomas K · Fairbanks, AKN1049TRoberts Kevin C · Athens, GAN1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104AHickman John E Jr · Coronado, CAN104ABPeterson Kevin D · Peoria, AZN104ACRoss Stephen D · Greenfield, OHN104AFNance David B · Quinton, VAN104ALDinardi Allen J · Jacksonville, ORN104BCHoudek Todd L · Roseburg, ORN104BLSpiva Brett · Knoxville, TNN104BVSea Horse Sportfishing LLC · Clinton, NCN104CCN104cc LLC · Fredericksburg, TXN104DFHayton Thomas M · Arcadia, OKN104DMMcalee Dennis E · Defiance, MON104EHaas Bruce F · Lynden, WAN104EDEdwards Aero Club · Edwards Afb, CAN104FFPlane Fun Inc Tr Trustee · Snellville, GAN104FGWilson Conrad · Bowdon Junction, GAN104GDFiebiger Mark D · Leesburg, FLN104GKIndigo Bunting Aviation LLC · Morristown, NJN104GPKline Michael S · Gypsum, CON104HPGenesis Aviation Enterprises Inc · Fort Lauderdale, FLN104JASkywest Leasing Inc · Saint George, UTN104JDJnk Equipment LLC · Deer Harbor, WAN104KGKing & Co LLC · Arroyo Grande, CAN104LDMasys Daniel R · Lincoln, CAN104LJFeldhousen Larry A · Burlington, CON104LULynn University Inc · Boca Raton, FLN104MEMathis Mark D · Richmond, TXFirst renewal noticeN104MFEccker Donald E · Ramona, CAN104MNCarpenter Jon Jay · Granada Hills, CAN104MQL C Whitford Co Inc · Wellsville, NYN104NPDv Aviation Inc · Brainerd, MN
Back to AD 2002-12-07