AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N6582FHemmatyar Nabi Z · Malibu, CAN6583FButterfield Rory A · Milan, NMN6583GRusch Steven A · Sequim, WAN6583QBernstein Matthew D · North Charleston, SCN6585FBrouse Dan T · Magnolia, TXN6585GPace Glen M · Columbia, MSN6585QJones Steve · Torrance, CAN6586FLunar Aviation LLC · Tahlequah, OKN6587FJones Aviation Inc · Biggs, CAN6587GGilkes Simon J · Gilbert, AZN65881Dudley Denise · Santa Margarita, CAN6588GAstro Aviation Inc · Whitney Point, NYN65890Beyler Mitchell L · Hamlin, NYN65891Cone John M · Conyers, GAN6589FRush Paul E · Highland, KSN6589SAdamson Paul B · Sparks, NVN6590FMapes Peter B · Oscoda, MIN6590SCoonley Russell F · Decatur, TXN65925Mccartney Kenneth R · Amarillo, TXN6592EPreszler Terence H · Braddock, NDN6592SBasista Robert J · Delaware, OHN6592TLill Steve P · Lafayette, LAFirst renewal noticeN6593SMilam David N · Hannibal, MON6594GKabat Orville · Rudyard, MIN6594QFantasy Fighters Inc · Santa Fe, NMN6595FRose Edward · Brooklyn, NYN6595SGlobal Flight Training Solutions Inc · Immokalee, FLN6596ELaughrey Jeffrey L · Soddy Daisy, TNN6596FTrenholm Daniel L · Eagan, MNN6596QAsk42 Ltd · Stary DebiecN6596TSuss Charles · Woodford, VTN65978Freeland Christopher G · Brownwood, TXN6597EPrintz Thomas L · Springfield, OHN65981Registration Pending · Dubuque, IARegistration pendingN65984Woelbing Aviation LLC · Franksville, WIN65985Moreira Hiosvany · Pensacola, FLN65986Ahern Michael · El Reno, OKN6598QMcdonnell David · Belle Plaine, KSN6598TSwanson Duane R · Simi Valley, CAN65997Dalton John C · Hernando, MSN6599FSiebe James E · Moscow, IDN659JHHammond James F · Yellow Springs, OHN65AWSmith David W · Byhalia, MSN65BBHoogasian Stephen M · Manassas, VAN65DGDeschweinitz Christian R · Anchorage, AKN65GMSalmonson Stefan Virgil · Mora, MNN65JGarrett Jeffery S · Waco, TXN65KPoland Linda J · Tawas City, MIN65MArata Steve · Corning, CAN65RGRandolph Clinton A · Bullhead City, AZ
Back to AD 94-05-05 R1