AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8966BSouthern Air Services Inc · Conway, ARN89673Jensen Jake J · Bayfield, CON89676Autumn Crucus LLC · Cincinnati, OHN8967RWindsock Holdings LLC · Amarillo, TXN8967SDemontgomery Peter J · Fyffe, ALN89680Evans Earl J · Oglethorpe, GAN89682Evans Dwight M · Nipomo, CAN89683Ellis Keith R II · Locust Grove, GAN89684Alum-I-Tank Inc · Harvard, ILN89687Allen Vincent J · Mckinney, TXN8968NMowery Robert · Irvine, CAN89690Warren Joy A · White Lake, MIN89691Johnson Warren Shane · Matheson, CON89695Rall Charles J · Mansfield, OHN89698Garrett James L · Paonia, CON8969BHeiter Christopher S · Leesburg, INN8969RRutland Aviation Service Inc · Tifton, GAN89709Guillory Howard C · Sulphur, LAN8970BVecchioni Ronald N · Chantilly, VAN8970RMerrell Susan E · Midland, MIN8970SMiller Curtis D · Malabar, FLN89715Bolton Derwin B · Jacksonville, TXN89728Kolterjahn Garth H · Green Bay, WIN89730Brick H Paul · Pomerene, AZN8973RDilliha Steve G · Russellville, KYN89740Brons Andrew S · Newfolden, MNN89742Jones Eric A · Colfax, WAN89744Mcculloch Allen W · Farmington, NMN89746Russell Keith M · Ivoryton, CTN8974BWaller Steven M · Sterling, CON8974SRegistration Pending · Bentonville, ARRegistration pendingN89754Bentch Mark W · Sedalia, MON8975DGrundy James W · W Greenwich, RIN89760Bollenbacher Stephen A · Fulton, NYN89762Fennig Barry L · Bryant, INN89765Miller Aviation Inc · Norton, KSN89766Rc White Aviation LLC · Wilmington, DEN8976SHattaway Laura C · Rossville, GAN89775Norman Charles E · Zanesville, OHN89777C&D D LLC · Conway Springs, KSN89785Baldwin Aaron J · Gig Harbor, WAN89788Mulder Albert · Midland, MIN89794Buechler Tryston M · Billings, MTN89798Bowen Bruce C · Sturgis, SDN89799Bahr Bradley R · Salem, ORN8979SFurtadobradley D · Lodi, CAN897CCCub Crafters Inc · Yakima, WAN897CTHildebrant Steven C · Newborn, GAN89801Dalton Berek · Owasso, OKN89809St Cyr Shane R · Plattsburgh, NY
Back to AD 94-05-05 R1