AD 94-05-05 R1
Registered aircraft · 26,231
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.
N3100HGregory Vernon L · Swansea, SCN3101ACosta Felipe R · Charlotte, NCN3101JRobinson David N · Colleyville, TXN3101XBlalock Bernnie R · Washington, OKN31026Renfro John R · Wendell, NCN31028R H K Of Kansas Inc · Overland Park, KSN3102NParker Steve E · Wasilla, AKN3102XJoshua Aircraft LLC · Georgetown, DEN3103JChiles Jimmy W · Rowlett, TXN3103VN3103v LLC · Wheeling, ILN31049Detwiler John D · Chaumont, NYN3104NWard David C · Mcpherson, KSN31063Qualitair LLC Trustee · MichelstadtN31067Marinangel Kathleen E Executrix · Mchenry, ILN3106BRegistered aircraftN3106EMiddleline Aviation Inc · Ballston Spa, NYN3107ATindall Michael E · Wahpeton, IAN3107EJones Donald T Jr · Yona, GUN3107XPage Trenton Vaughn · Warner Robins, GAN3108AMccutcheon Jeffery T · Clinton, LAN3108FSuntech LLC · St George, UTN3108JBetzoldt Linda · Tecumseh, MIN31092Covell Tim N · Healy, AKN3109EDexter Fred H · Live Oak, FLN3109JShue Robert R Jr · Easley, SCN31117Benfer Scott · Monroeville, OHN3111ELochner Richard A · Eagle River, AKN3111NGavagan Harold R · Chandler, AZN31120Bensyl William · Park City, UTN31125I Fly Enterprise · Lexington, NCN31126Krug Gene G · Medford, WIN3112BParslow Wayne · Puyallup, WAN3112HTietze Thomas N · Olathe, KSN3112NMoore Jarrel D · Waelder, TXN3113XAfp Aerospace LLC · West Palm Beach, FLN31140Brown Doyle E · Jonesboro, ARN3114JHibner Joseph W · Coldwater, OHN3114NClassic Aviation Inc · Pella, IAN3115BKegley Gary L · Perrin, TXN3115EBushman Kyle P · Pleasant Hill, ORN3115NYork Ersell Shane · Ramseur, NCN3115VBarkman D Barry · Naples, FLN3115XReeve Howard E · Minot, NDN31160Caliber Air LLC · Wasilla, AKN31165Hackenburg Jess P · Montoursville, PAN31169Mcdevitt Charles P · Bridgeport, WVN3116ASchanche Carsten H · Marstons Mills, MAN3116XRegistered aircraftN3118VKemper Joseph C · Coxs Mills, WVN3118XMoody Dalton T · Evansville, IN
Back to AD 94-05-05 R1