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.
N70852Rogers David A · Windham, MEN7085EArmstrong Bruce · Port Orchard, WAN7085SMatthews Suzanne M · Horseheads, NYN7085TKelley Geoffrey A · Wichita, KSN7085XGorman Michael G · Zephyr Cove, NVN7086ATugmon Danny Lee · Locust Grove, OKN7086FCooley Dennis Andrew · Wasilla, AKN7086XYocum Stuart · Kingman, AZN7087FParnell Don E · Alexandria, LAN7087TLakelands Flyers LLC · Greenwood, SCN7088DShoup Greg L · Pierre, SDN7088FVander Mey Thomas H · Aitkin, MNN7088MCrouse Dewayne O · Eagle River, AKN7089ARuotsi Tony M · Beaver Island, MIN7089MWolgemuth Mark P · Lowell, INN708CCOlivier Seth N · Baskin, LAN708HKKliner Henry J · Wilmot, SDN708RFHilton Charles Larry · Arcadia, FLN70906Giersch Michael L · Madera, CAN7090XGoodrich Dianna L · Sebastopol, CAN70914Schumacher Bradley R · Elma, NYN70918Almand Todd L · Keller, TXN7091SMoyer Alan L · Perkasie, PAN7091TJensen William Robert · Zephyrhills, FLFirst renewal noticeN7091XPonnequin Craig R · Marsing, IDN70923Collins Dennis L · Richland, WAN70924Steed Brian · Winnsboro, SCN7092MBohlke Cliff J · Prosser, WAN7092XJackson Roy M II · San Angelo, TXN7093AValle Daniel J · Canton, MIN7093ERollins James A Trustee · Laconia, NHN7093MSentz Daniel J · Wasilla, AKN7093XDreiling Timothy A · Lawrence, KSN70942Chapman Maxwell A · Menasha, WIFirst renewal noticeN7094FLarsen Gary A · Honolulu, HIN7094SEdwards Thomas · West Richland, WAN70955James Clay · Concord, NCN70957Hendrick Jerry R · Oroville, WAN70958Froh Samuel · North Pole, AKN7095SSutton Aircraft Salvage LLC · Palmer, AKN7095TCurrence Brian J · Rock Hill, SCN70964Lechner Burdetter J · Kodiak, AKN7096AWhite Lee A · Columbus, OHN7096FJanuary Lynn E · Mcpherson, KSFirst renewal noticeN7096JHutfless Roger P · Davenport, WAN7096XMoran Margaret Smith · Como, MSN7097MLevine Jay Jacob · Los Angeles, CAN7098EHucul Kenneth G · Phoenix, AZN7098FBumps Stephen D · Gilead, MEN7099FMiles Del R · Blackfoot, ID
Back to AD 94-05-05 R1