AD 2002-19-03
Registered aircraft · 12,723
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-19-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:2002-19-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:2002-19-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:2002-19-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.
N1044NMaule Flight Inc · Moultrie, GAN10457Six Ten Ventures LLC · Cedar Hill, TXN1045YRovers Bradley S · Chazy, NYN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1048DDumbravo Dustin C · Yorktown, VAN1049TRoberts Kevin C · Athens, GAN1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104ABPeterson Kevin D · Peoria, AZN104ALDinardi Allen J · Jacksonville, ORN104AZJarrell Rodney M · Phoenix, AZN104BKCharlie Alpha Bravo LLC · Spring Hill, KSN104BRBelsaas Richard A · Rapid City, SDN104CDOlson Timothy D · Elk Mound, WIN104DPMajul Enterprises Inc · Saint Petersburg, FLN104EHaas Bruce F · Lynden, WAN104EEWestfall Benjamin C · Coeur D Alene, IDN104EPEarwood Edward A · Sonora, TXN104GKIndigo Bunting Aviation LLC · Morristown, NJN104GRMargolis David · Tucson, AZN104JGRoscioli Lamberto · Lighthouse Point, FLN104KGKing & 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, NYN104NRainey Norman W · Surprise, AZN104RGWeiss Elliott · Fresno, TXN104TEN104te LLC · Tucumcari, NMN104WHGreycal Enteprrises Inc · Lake Mary, FLN104XPRv X Aviation LLC · Draper, UTN104ZURuttler James J · Bremerton, WAN1050BNine1on Industries LLC · Helena, MTN1050QCouch Kelly P · Elk Grove, CAN1051ZDranttel Timothy John · Fuquay Varina, NCN1053BLoveland Inc · Vance, MSN1054QTaylor Hauling II LLC · Laurel, MSN1054TInternational Air Services Inc Trustee · Carson City, NVN10555Mccrea Daniel B · Waldport, ORN1057TMclane Trailer Sales Inc · Poplar Bluff, MON105CBFlying Squirrel Aviation LLC · Blacksburg, VAN105CHMach Tuck LLC · Daytona Beach, FLN105DGFraser And Daughter LLC · Saint Augustine, FLN105HPRyan Transportation Services Ltd · Marysville, OHN105JMBullard Roy P · Granbury, TXN105RCOlds Rodger C · Prescott Valley, AZN105TCMark Johnson And Sons Plumbing LLC · Ruston, LAN105TLSlay Brothers Enterprises LLC · Winter Haven, FLN1062UNathan John K · Seabrook, TXN1063CJim Johnson Nissan Inc · Bowling Green, KY
Back to AD 2002-19-03