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.
N7908UBrogan Scott D · Bellevue, OHN7908ZOnyx Performance Aviation LLC · Bakersfield, CAN7909ENeiggemann Patrick B · Ventura, CAN7909FK-Air Inc · Egg Harbor, WIN7909XEisenhauer Lyle M · Sterling, NEN7910BJohnson John A Trustee · Sandy, ORN7910EBobbitt Charles W · Madill, OKFirst renewal noticeN7910UStechschulte Jason P · Fort Jennings, OHN7910ZCooper Jeffrey S · Honeoye Falls, NYN7911BDaugherty Monte R · Anderson, INN7911XRice David L · Dickson, TNN7912ECallahan Richard T · Lancaster, CAN7912USweet Breeze Aviation LLC · Gordonsville, VAN7912XWang Jinrao · Riverdale, GAN7913BLand Terry · Adamstown, MDN7913TBorsheim Richard R · Red Lodge, MTN7913UKashmir Air Inc · Somerset, NJN7913ZBernhardt Michael J · North Branch, MNN7914ESteiner Ward · Clayton, CAN7914FPrater Stewin W · Chillicothe, OHN7915AStearman Aviation Inc · Crawford, CON7915BGriesman Scott W · Sandy Valley, NVN7916EFisher David N · Memphis, TNN7916TJohnson Colton M · Katy, TXN7916UDillehay James L Trustee · Canyon, TXN7916XMick Edward W · Harrisburg, ILN7916Z$100 Hamburger LLC · Snohomish, WAN7917EProby Trevor J · Adkins, TXN7917TAndersen Dana K · Scappoose, ORN7918TStrand Michael · Conroe, TXN7918UJensen Peter E · Rio, WIN7918ZHunter Stuart R · Burgaw, NCN7919ENicodemus Trey M · Springfield, OHN7919XAirheads LLC · Lake City, MIN791CCScarbrough Dean · Deshler, OHN7920BThompson Deven B · Richland, ORN7920FFalk William P · Milford, CTN7920UHudecek Robert J · Grapevine, TXN7920ZKts Spar Bay LLC · Coral Gables, FLN7922BManley Ronnie H · Belleville, MIN7922UButler Brandon R · Redmond, ORN7922ZBrown Gary W · Abilene, TXN7923EKelly Charles Michael · San Angelo, TXN7923TPop Ciprian S · Reno, NVN7923UDumont William L · Wellston, MIN7924UDownwind Corp · Brush Prairie, WAN7924ZToothman Timothy L · Xenia, OHN7925BBache Harold F II · Gainesville, GAN7926BRussellaire LLC · Holt, FLN7926ELtg Enterprises LLC · Fort Wayne, IN
Back to AD 94-05-05 R1