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.
N72401Coleman Aero Club · Apo AeN7240AIrwin Timothy L · Cottonwood, AZN7240XGootee Gregory A · Anchorage, AKN7241AGibbs Geoffrey M · Holland, TXN7241MLabarre Ben A · Hayward, WIN7241TSelleck Philip A · Falls Church, VAN72425Grant James L · Cameron Park, CAN7242TDenton David · Siloam Springs, ARN7242XWatson Kenneth B · Sanford, TXN72431Katzman Solomon J · Santa Cruz, CAN72433Moore Jarrel D · Waelder, TXN72435Meruelo Andrea M · Ouray, CON7243NGray Gordon Thomas · Redmond, ORN7243SEggers Matthew O · Keller, TXN72440Livingston Edward M Jr · Crestview, FLN72441Michael Kenneth L · Omaha, NEN7244TFlood John M · Bozeman, MTN72457Reavis John F · Harmony, NCN72458Guritz John G · Dunlap, CAN7245AStoup Kyle W · Foss, OKN7245SHansen Abree G · Reno, NVN7245TWestfall James H · Bend, ORN7245XBelliveau Brian J · Easthampton, MAN72460Harms Dakota J · Newton, KSN72464Tarr Sheryl L · Spokane, WAN7246HZuloaga Lante Alejandro M · Miami, FLN7246SDenton Christopher G · Youngsville, NCN7246TKruger Bruce W · Gustavus, AKN7246XMuinos Jose M · York, PAN72477Ground Loop LLC · Clemmons, NCN7247MChristopher James R · College Park, GAN7247SEpperly Scott E · Creswell, ORN7247TNelson Harold G · Pendleton, ORN7247XGritter Robert C · Hudson, FLN72481Greenland Gary L · Three Springs, PAN72482Martin Peter · Seattle, WAN72483Lasalle Charles H · Williamstown, NYN72484Denly James E · Erie, CON72485Devane Alvin E · Oklahoma City, OKN72489Armor Air Corp · Foristell, MON7248AMoore Greg J · Bakersfield, CAN7248KHarnisch Brandon R · Shelton, WAN7248TStormont Dylan · Xenia, OHN72495Georges Frederick K · Seward, AKN72496Cannon Daniel T · San Diego, CAN72498Dairy Air Inc · Wyoming, PAN72499Vanbeber Richard L · Collinsville, OKN7249MNewell Norman I Jr · Palm City, FLN7249XZubeck Robert E · Emery, SDN724ABReiley Richard H · San Antonio, TX
Back to AD 94-05-05 R1