AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N777VVDeluxe 8 LLC · New Orleans, LAN777WECentral Texas Shuttle Service LLC · Wilmington, DEN777WVIndependent Mortgage · Westlake, LAN777WXMullins William Scott · Senoia, GAN777XXAustex Aviation Group Inc · Austin, TXN777YFLandsgaard Equipment Leasing LLC · Wellington, CON777YPTim Edwards Co LLC · Wilmington, DEN77877Air Vector LLC · Bountiful, UTFirst renewal noticeN7788HTeodoro Financial Group Inc · Mill Valley, CAN778CAMas Aviation LLC · Laurel, MSN778CWGarbati Thomas Jr · Waterford, CTN778DAT And S Capital Holdings LLC · Tampa, FLN778DBHage Enterprises LLC · Portsmouth, NHN778GTMckenna Equipment LLC · Casper, WYN778KB618lb LLC · Knoxville, TNN778MMTapley Aviation LLC · Wilmington, DEN778PZG3 Aviation LLC · Cranston, RIN778TPMotleys Air LLC · Richmond, VAN778WTSky Ventures LLC · Plaistow, NHN7797SBaker Brian · Stanton, TXN7798NGebhard John M · Hartland, WIN7799RRice Kenneth L · Payson, AZN779COweis Yaseen · Bellaire, TXN779DBAirjohn LLC · Cheyenne, WYN779GWBuzzard Flop Aviation LLC · Celina, TXN779JWFaero LLC · Bakersfield, CAN779RJN779rj LLC · Centennial, COFirst renewal noticeN779SRNorton Thomas W · Dayton, NVN779TWClassic Flyers LLC · Indianapolis, INN779WCLane William Michael · Green Bay, WIN779WSCoeruleus Aviation LLC · Coeur D Alene, IDN779ZSLumen Wings LLC · Seattle, WAN77ACEagle Aviation Consulting LLC · Wilmington, DEN77BRInternational Air Services Inc Trustee · Carson City, NVN77BVRegistered aircraftN77CDN-J Aviation LLC · Forest, VAN77CKRaiz Coaching LLC · Fort Worth, TXN77CXAces High Aviation LLC · Tulsa, OKN77DEHaag Michael E · Granite Bay, CAN77EYMile 6 Aeronautics LLC · New Berlin, WIN77GJSees Aviation Inc Trustee · CheltenhamN77HCHlh Properties LLC · Cohutta, GAN77HGMyles Offshore Inc Trustee · Wilmington, DEN77KDExcell Partners Inc · Tampa, FLN77KRMarsh Aviation LLC · Old Lyme, CTN77LVAviacion Del Oeste Inc · Mayaguez, PRN77LYLightyear Aviation LLC · Ivins, UTN77NWRizor Justin · Phoenix, AZN77PGJjo Aero LLC · Keller, TXN77PHRiddick Aviation LLC · Columbia, MO
Back to AD 2012-10-13