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.
N77QBDeauxboys LLC · Menomonee Falls, WIN77RASky West Aviation Inc Trustee · Albuquerque, NMN77RTBouchier Thomas B · Post, TXN77ZMHp Aviation LLC · Little Falls, MNN780AKZobo Enterprises LLC · Alameda, CAN780CDGreene James W · League City, TXN780JBAc22 LLC · Los Angeles, CAN780MBSky West Aviation Inc Trustee · Albuquerque, NMN780MDBerchiatti Geno R · Greenville, SCN781CBMiller Charles Litle Trustee · Fresno, CAN781CWSwf Investment Inc · San Francisco, CAN781DBCooper Roy · Lamesa, TXN781JKJjk Aviation LLC · Harland, WIN781PWPf Flyers Inc · Lavonia, GAN781SRRegistration Pending · Scottsdale, AZRegistration pendingN781TCKeystone Ridge LLC · Colorado Springs, CON781TH7817 LLC · Paradise Valley, AZN782Dillon T34 782 LLC · Scottsdale, AZN7822MAero Rocket LLC · Las Vegas, NVN782ASU Fly Aviation LLC · Campbell Hall, NYN782CDArbuckle Roger · Greenville, KYN782KJSrl Investments LLC · Boone, IAN782PGUltimax Aviation LLC · Columbus, OHN782RBSkarco LLC · Burlington, CON782SRN782sr LLC · Missoula, MTN783ABDelta Sr Nc LLC · Raleigh, NCN783JMTime Machine LLC · Newton, ILN783JR13 Aviation LLC · Chelan, WAN783KAKalex Enterprises Inc · Kingston, MAN783LXGenetech Animal Reproduction LLC · Purcell, OKN783MKDove Si Trova La Stazione Di Tren LLC · Lafayette, CAN783RJMlc Aviation LLC · Sewickley, PAN783SRZarate LLC · Miami, FLN7841QExigo Capital LLC · Miami Beach, FLN7845QReading Jared · Uvalde, TXN784CAEagle Capital Holdings LLC · Doylestown, PAN784CDRay Matthew C · Powell, OHN784CECharlie Echo LLC · Chico, CAN784MB784cb LLC · Las Vegas, NVN784RJDove Street Associates LLC · Corona Del Mar, CAN784SECounty Management Inc · San Diego, CAN7855LJrm Equipment LLC · San Francisco, CAN7855ZRoskowski David · Charlestown, INN7858PRegistered aircraftN785BFlyright Ventures LLC · Las Vegas, NVN785BBWarehouse #41 LLC · Wake Forest, NCN785CDPresidio LLC · Manhattan, KSN785MXtwa Cirrus LLC · Rio Verde, AZN785SYAircraft Trustee Services Inc Trustee · Dover, DEN7864FKeller Russell L · Runaway Bay, TX
Back to AD 2012-10-13