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.
N98616Le Loi · Baton Rouge, LAN9861YRichard I Bennett LLC · San Jose, CAN98624Jensen Hans · Gig Harbor, WAN9862FX7 Ranch Inc · Merino, COFirst renewal noticeN98649Dodson International Parts Inc · Rantoul, KSN986CBMap Leasing LLC · Greenleaf, WIN986CDDe Aguiar Sebastiao Fogaca · Miami, FLN986DTHolroyd Aviation Inc Trustee · Wilmington, DEN986GMGospel Ministries International Inc · Collegedale, TNN986JTDirect Sight Aviation Inc Trustee · Wilmington, DEN986MSRush Aviation LLC · Hayden, IDN986SAscend Partners Funding LLC · Sacramento, CAN986WLLeggett Consulting LLC · Brookhaven, MSN9870YDejong Arie H · Maricopa, AZFirst renewal noticeN98725First Flight Corp · San Diego, CAN98747American Skyways Inc · Corning, NYN9876ZGv Air Inc · Medford, ORN987CARed Bird Partners LLC · Newark, DEN987CDTrike Industries LLC · Draper, UTN987JSAmerican Star Aviation LLC · Ithaca, NYN987KCAsberry Gregg J · Sidney, ARN987PLColestine Holdings LLC · Ashland, ORN987TMRgm Aviation LLC · Brentwood, TNN987TTEllison Thomas Andrew · Parker, TXN987WEstrada Alfonso · Santa Teresa, NMN987WTRangerair LLC · Melbourne, FLN98869Keystone Aerial Surveys Inc · Philadelphia, PAN988CBDrill Pro LLC · Wilmington, DEN988CDKading Kevin · Tucson, AZN988DMHart Paul E · El Macero, CAN988JGSaratoga Aviation LLC · Wilmington, DEN988JLL 3 Air LLC · Weston, WIN988SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN988TJGossman Aviation LLC · Bloomfield Hills, MIN988YTMdf Ventures LLC · Los Angeles, CAN9890YValiair Lc Trustee · Casper, WYN9894YRaymond Andy · Council Bluffs, IAN98952Jim Leasco LLC · Ottawa Hills, OHN989AAMouat Brian · Trent Woods, NCN989BHookey Aviation LLC · Jackson, WYN989BDGlacier Aircraft 3 LLC · Orlando, FLN989BEPerformance Air LLC · Hobbs, NMN989CAircraft Partner Holdings Inc Trustee · BerlinN989DValiair Lc Trustee · Casper, WYN989DFKearns Floyd M · Houston, TXN989ECHagan Aaron Kirk · Park City, UTN989HKTailwinds Aviation LLC · New Orleans, LAN989MBBhasin Monica · Holtsville, NYN989MPSgl LLC · Dubuque, IAN989PSReliable Property Solutions LLC · Stockbridge, GA
Back to AD 2012-10-13