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.
N7978ESalyer Spencer · Modesto, CAN7978UNorthwoods Gateway Aviation LLC · Antigo, WIN7978ZFlint Harry L · Falls City, NEN7979FAtkins Adam T · Fort Mill, SCN7979TIvy James H III · Seligman, AZN7979ZLindenschmidt Eric J · Mount Vernon, INN797DJN797dj LLC · Fayetteville, GAN797PTCortelyou John B · Pittsburg, TXN797WDBuraceski John S · Faribault, MNN7980BMikesell Luke A · Fairland, OKN7980EEhrhardt Eric · Wauconda, ILN7980ZMartin Tyler · Rexburg, IDN7981TAshmore Rod L · Bonita Springs, FLN7981USkyhawk Aviation LLC · Midland, MIN7982BUlmer Brian K · Huachuca City, AZN7982EBodin Logan · Lake Charles, LAN7982FPlane Sane C1 LLC · Cary, NCN7982ULastowski Jeffrey A · Mooresville, INN7983FKoons Brian D · Canton, OHN7983XLine Ricky L · Liberty Hill, TXN7984BYoung Kenneth R · Waco, TXN7984UButter Kendall L · Gatesville, TXN7985XDoughty Phillip T Jr · West Monroe, LAN7986THendrickson Robert E Jr · Royal Oaks, CAN7986ZEvans Joe E · Cheboygan, MIN7987FMillican Troy · New Ulm, TXN7987GHigh Expose Inc · Woodbine, NJN7987UFrick Gary A Trustee · Marion, INN7987ZJohns Dennis O · Royse City, TXN7988TBooher David W · Shirleysburg, PAN7989UA-Cent Aviation Inc · Jacksonville, FLN7989ZLunsford William E · Delaware, OKN7990EYankoviz Frank T · Monett, MON7991BLowe Gayle C · Sacramento, KYN7991EMiller Samuel A · Westphalia, KSN7991UAlternate Air Inc · Seattle, WAN7992TMoyle Mark S · Fallon, NVN7993BAlmy David W · Riverside, CAN7993UKrecek Jason · Hiram, OHN7994UScott Geoffrey H · Jacksonville, FLN7994XRegistered aircraftN7995BOtey Robert J · Goldendale, WAN7995TNacarato Justin K · Fort Worth, TXN7996BG & R Flying Ltd · Chippewa Falls, WIN7996FRounds Donald C DBA · Waller, TXN7996UVolare Of Sc LLC · Myrtle Beach, SCN7996XBuchhorn Larry R · Fredericksburg, TXN7997ESmith Andrew H · BramfordNon-citizen corporation, flight hours not reportedN7997ZDerry John · Monroe, MIN7998ECunha Eduardo · Rochester, NY
Back to AD 94-05-05 R1