AD 2002-23-06
Registered aircraft · 16,325
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-23-06')
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-23-06')
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-23-06') 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-23-06') 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.
N103GLNaylor Aviation LLC · Columbia, MON103HPMcfarland Natalie · Roseburg, ORN103KCLang Elmer N · Hemphill, TXN103MRDeepvine Partners LLC · Simonton, TXN103NCState Of North Carolina · Raleigh, NCN103PZRaging Thermal Sky Sports LLC · Brighton, CON103RRLancaster Flyers LLC · Fenwick Island, DEN103SJBarnick Air Holdings LLC · Santa Barbara, CAN103TXWilliams Bradley H Jr · Charleston, SCN103URankin Kenneth · Pinellas Park, FLN1041CHelzer Timothy · Tucson, AZN1041HCentury Flight Systems Inc · Mineral Wells, TXN1044LFitch Mark · Anchorage, AKN1044NMaule Flight Inc · Moultrie, GAN10457Six Ten Ventures LLC · Cedar Hill, TXN1045YRovers Bradley S · Chazy, NYN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1047YDonato Deleonardis · Paulden, AZN10480Piper 66 LLC · Kirksville, MON1048DDumbravo Dustin C · Yorktown, VAN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049TRoberts Kevin C · Athens, GAN1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104ABPeterson Kevin D · Peoria, AZN104ALDinardi Allen J · Jacksonville, ORN104DMMcalee Dennis E · Defiance, MON104EHaas Bruce F · Lynden, WAN104GKIndigo Bunting Aviation LLC · Morristown, NJN104KGKing & Co LLC · Arroyo Grande, CAN104LDMasys Daniel R · Lincoln, CAN104LJFeldhousen Larry A · Burlington, CON104MEMathis Mark D · Richmond, TXFirst renewal noticeN104MFEccker Donald E · Ramona, CAN104MQL C Whitford Co Inc · Wellsville, NYN104MXFrancis Scott P · Montclair, VAN104RGWeiss Elliott · Fresno, TXN1050BNine1on Industries LLC · Helena, MTN1050QCouch Kelly P · Elk Grove, CAN1051ZDranttel Timothy John · Fuquay Varina, NCN1053BLoveland Inc · Vance, MSN1053WPcxii LLC · Greensburg, INN1054QTaylor Hauling II LLC · Laurel, MSN1054TInternational Air Services Inc Trustee · Carson City, NVN10555Mccrea Daniel B · Waldport, ORN1057QLofty Goals Aviation LLC · Liberty Lake, WAN1057TMclane Trailer Sales Inc · Poplar Bluff, MON1057ZAcc Transport LLC · Pomona, CAN105AAWehrmacher James P · Crawford, CON105CBFlying Squirrel Aviation LLC · Blacksburg, VA
Back to AD 2002-23-06