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.
N8835GNelson Joel B · Alliance, OHN8835SWinchester Holdings LLC · Monticello, MNN8835ZMaloney Eric T · Houston, DEN88363Beltz Christina R · Canyon, TXN8836UWhite Charles A · Rch Palos Vrd, CAN8838BMason City Enterprises LLC · Mason City, NEN8838ZG2g Aviation LLC · Wray, CON8839BRiberio Trucking LLC · Stratford, CTN8839GRegistered aircraftN8839USchuh Thomas M · Queen Creek, AZN8839ZCole Samuel L M III · Kenai, AKN8840SBlue Thunder Aviation LLC · Heath Springs, SCN8840UHathor Aviation LLC · Johnstown, CON88411Ruehle Nancy J · Gunnison, CON8841BErwin Brandon · Jacksboro, TXN8841GLinn Parker J · Brainerd, MNN8841UNorcal Flight Center LLC · Lincoln, CAN8842GTiller Stanford C · Loup City, NEN8842UHwa LLC · Charleston, SCN88431Tondi David M · Sterling, VAN8843BBaker Ralph · Lake Geneva, FLN8843GSanders Don · Mustang, OKN88441Carter Lonnie W · Parkville, MON88445Larson Dustin · Baldwin City, KSN8844ZTerry L Fowler LLC · Greenbrier, ARN8845BB1rd Flying LLC · Hotchkiss, CON8845ZCartwright Adam C · Homestead, FLFirst renewal noticeN8846USmith Chad · Boulder City, NVN8847BSeymour John R · Findlay, OHN8847GSabillon Luis H · Concord, CAN8847URuo Hiko · Petaluma, CAN8847ZChristian Matthew T · Sebring, FLN88485Daniel Brian L · Linn, MON8848GFlynn John P · Colebrook, NHN8848ZMix Gary · Hoagland, INN88499Lawthers William T · Tehachapi, CAN8849GSustarich Stephen M · Ketchikan, AKN8849ZBagwell Aaron Edward · Mount Vernon, WAN884WHPr Aeronautics LLC · Buffalo, SDN8850GSchool Board Of Seminole County Florida · Sanford, FLN8850SFlyers Park Farm LLC · Newark, OHN8850UA & H Renovation LLC · Woodstock, GAN88511Timblin Joel R · Boyceville, WIN8851SChamseddine Ahmed A · Middletown, RIN8851UBaird Mark · Emeryville, CAN8852BShuck Herbert K · Meadow Bridge, WVN8852GAmis Jan E · Weeki Wachee, FLN8853UDrakes Landing Inc · Archibald, LAN8855GAldrich Curtiss R · Big Oak Flat, CAN8855UBaginski D D · Salesville, OH
Back to AD 94-05-05 R1