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.
N817PSSutton Aircraft Salvage LLC · Palmer, AKN817RLPalouse Ag Leasing LLC · Moscow, IDN818High Alpha Airshows LLC · Santa Rosa Valley, CAN81803Champ 81803 LLC · Clinton, MON8180ANipp Michael P · Nampa, IDN8180BNiehaus James O · Erie, CON8180LManser Andrew R · Neenah, WIN81810Vintage Combat Aircraft LLC · Wilmington, DEN8181BManning Richard F Jr · Midway, GAN8181SCopeland Kevin D · Vidalia, GAN8181THetge Kenneth R · Viola, ARN8181UMillman Chris · Auburn, WAN81823Mcgill Melissa M · Joliet, MTN8182UMorristown Flying Service Inc · Talbott, TNN81834Kurtz Garold D · Mound City, MON8183ARegistered aircraftN8183FArvizu Jason Arthur Scott · Bakersfield, CAN8183THysell Donovan · Atwater, OHN8183UMacauley Richard D · Shingle Springs, CAN8184BPalouse Aviation Holdings LLC · Moscow, IDN8184LVanderlaan Dirk C · Reno, NVN8184TGraham Steven K · Mc Grath, AKN8185SJanssen Christopher M · Manchester, IAN8185VCryan Mark · Port Orange, FLN81868Henderson William Gary · Lake Worth, TXN8186BMid-Atlantic Aircraft Leasing LLC · Wilmington, DEN8186LBolsover Douglas J Sr · Cameron Park, CAN8186TBouton Vern H · Fairbanks, AKN8186ULake Area Technical College · Watertown, SDN81875Suits Thomas L · Tulsa, OKN8187BWithers Hurchel W · Stone Mountain, GAN8187FCoady Michael J · Taylorville, ILN8187SCounter Kevin · Windsor, CAN8187VNelson Brett R · Shoreview, MNN8189AEight Niner Alpha LLC · Eagle, IDN8189FArchuleta Michelle L · Las Cruces, NMN8189XQuire Gregory L Sr · Shepherdsville, KYN818BCKingsbury Gwendolyn · Indianola, IAN818MLTurning Point Northwest LLC · Stanwood, WAN818SWAbbott Don W · Sanibel, FLN8190LOlsen Curtis O · Lindon, UTN81910Leaders Bob · Clear Lake, MNN8191FMoore Clayton P · Cayce, SCN8191SStang Daniel Jr · Lindale, TXN8191TDavis Jonathan L · Pleasanton, CAFirst renewal noticeN8191UAnderson Amy J · Manistique, MIN81920Crooke Michael J · Charlotte, NCN81927Elliott Joel C · Pacoima, CAN8192BAll Sports Aviation LLC · Sandpoint, IDN8192LSteinmetz William · Lakeville, IN
Back to AD 94-05-05 R1