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.
N717VVSouthern Kentucky Flying Club LLC · Bowling Green, KYN7181AWarmkessel James R · Felton, CAN7181FCarter Mark A · Carpinteria, CAN7181MArmstrong Bruce · Port Orchard, WAN7181TSwanson G N · Meridian, IDN7181XMozina Robert J · Mc Alpin, FLN71829Vaknin Michael · Pleasant Prairie, WIN7182AEdm Flying Inc · Nevada, MON7182MThayer Stephen Claude · High Point, NCN7182SHoward William M · Greensburg, PAN7182TTdp LLC · Caldwell, IDN7183AElk & Ram Aviation Group LLC · San Antonio, TXN7183FN7183f LLC · Spanish Fork, UTN7183MSnavely Deborah B · Lake Placid, FLN7184Burgess Phillip G · Fairfield, PAN7184AGarrison Randy L · Queen City, TXN7184FYoke Aviation LLC · Bowling Green, KYN7184SCade Steven V · Lopez, WAN7184THelderman Laban W · Newton, NCN7186SEagle Equity Inc · Valparaiso, INN7186XSmith Calvin E · North Augusta, SCN7187AHannah David W · Richmond, TXN7187FHoranzy Paul S · N Grosvenordl, CTN71887Wieland Jeffrey K · Elk Grove, CAN7188FCopeland Lance Andrew · Jacksonville, ARN7188HNewhouse James R · Sycamore, ILN7188MFilter Keith Jr · Lake Havasu City, AZN7188XSky West Aviation Inc Trustee · Albuquerque, NMN7189APierson Janice R Trustee · Scio, ORN7189FTello Ricardo · Mission, TXN7189XZephyr Air Corp · Dellwood, MNN718CCSky Aviation LLC · Bloomville, OHN718DFTurning Point @ Sonrise Inc · Hartsville, TNN718RMHancock Travis S · Longview, TXN7190MDiener John M · Stephenville, TXN7191GHis Grace LLC · San Angelo, TXN7191TLawson Isaiah · Roswell, NMN7191XMiller William D · Blacksburg, VAN71936Winell Carol D · Orange, CAN7193TJones Wade T · Wichita, KSN7193XRound Engine Aero · Nashville, MIN7194AGuillermo A Pliego M · Corpus Christi, TXN7194THall William A · Puyallup, WAN7195FAustin Richard K · Ludington, MIN7195MFussy Bernie P · Bowlus, MNN71962Aerotrack Inc · Hemet, CAN7196AL-Bird LLC · Hood River, ORN7196FStarr Benjamin M · Somerset, OHN7196SSale Reported · Taylorsville, MSSale reportedN7197MKansas Soaring Association · Wichita, KS
Back to AD 94-05-05 R1