AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2439TSkylane 2439t Partners LLC · Burlingame, CAN2439ZPlane Nonsense Inc · Middletown, DEN243AAFf22 LLC · Scottsdale, AZN243ATAirline Transport Professionals Corp Of USA · Wilmington, DEN243AURunamuck LLC · New Orleans, LAN243CGTampa Bay Soaring Society · Zephyrhills, FLN243CPCivil Air Patrol · Maxwell Afb, ALN243CYHarvey Steven T · Honolulu, HIN243DBMainpro Inc · Alexandria, KYN243EHVeracity Aviation LLC · Seguin, TXN243EPEpic Aviation Inc · New Smyrna Beach, FLN243GArcher Aero LLC · Wilmington, DEN243HAAtp Aircraft 8 LLC · Wilmington, DEN243JAYale Companies LLC DBA · Indianapolis, INN243JGBateman Scott R · Montrose, CAN243JHFlowers Derrick W · San Antonio, TXN243JWUhles Denny · Bakersfield, CAN243MCRankin John · Nokomis, FLN243MDWhiteis Barnabas G · Apex, NCN243MEMcaleer William V Jr · Milledgeville, GAN243MGGeorgia Aviation Authority · Eastman, GAN243PSN9089 LLC · Lewes, DEN243RLAtp Aircraft 8 LLC · Wilmington, DEN243SDSouth Dakota State University · Brookings, SDN243SPBarbers Point Flight School LLC · Kapolei, HIN243TJJones Helicopters LLC · Villa Rica, GAN243XJLoiacono Vincent · Sunfield, MIN243YShilt Jerry C · El Dorado Springs, MON2440DXing Kong Aviation Service LLC · Atwater, CAN2440PN2440p LLC · Seattle, WAN2440QTeanaway Ventures Consulting LLC · Cle Elum, WAN2440VVehrs Roger K · Roseburg, ORN2441DKsm Aviation Inc · Wilmington, DEN2441EMyf Holdings LLC · San Diego, CAN2441GTognoli Stefano F · Union, ORN2441MBlackburn Alan Ryan II · Palm City, FLN2441YTag Aviation LLC · Santa Teresa, NMN24429Pniak Robert J · Carmel Valley, CAN2442QCoastal Business Systems Inc · Eureka, CAN2442VBarts Flying Service Inc · Storm Lake, IAN2443HSilver Star Jet LLC · Delafield, WIN24447Mustang Sally Aviation LLC · Camden, SCN2444HChristiansen Aviation LLC · Wilmington, DEN2445JBuzzard Aviation Inc · Freer, TXN2445RVan Bortel Aircraft Inc · Arlington, TXN2445VN2445v Cessna Inc Trustee · Wilmington, DEN2446ASkybound Aviation LLC · Bixby, OKN2446ESugarloaf Air LLC · Wilmington, DEN2446REdgon Inc · Orlando, FLN2446SFerreby Thomas E · Stroudsburg, PA
Back to AD 2006-10-21