Skip to content

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

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

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.

N3219LBlock Taylor I · Sibley, IAS/N 17256119 N321BBBreckenridge Rebecca S · Mulino, ORBuilt 2016 · S/N MK-106 N321BMMacintosh William J · Simpsonville, SCBuilt 1966 · S/N 17254361 N321RSMadsen Steven L · Colgate, WIS/N 321 N321TMOlson Bradley J · San Ramon, CAS/N 2328 N321TXMartin James K · Kingsville, TXBuilt 1967 · S/N 15067252 N3221VDevaney Aviation Inc · Palm City, FLBuilt 1974 · S/N 15076426 N3222HRhodes Bobby T · Palmdale, CABuilt 1946 · S/N 3847 N3222LLanier James A · Phillipsburg, KSBuilt 1967 · S/N 17256122 N3223JPoulin Philip N · Washington, VTBuilt 1966 · S/N 15065923 N3223LBerube Leo Reginald · Easley, SCBuilt 1967 · S/N 17256123 N3224ARoy Timothy R · Cottrellville, MIBuilt 1953 · S/N 25868 N3224HLeonardo Alan W · Higbee, MOS/N 3849 N3224KBoronkay Peter H · Rockwall, TXBuilt 1946 · S/N 1217 N3225ASantacroce Anthony M · Cedar Rapids, IABuilt 1953 · S/N 25869 N3225LWing Nuts Inc · Maryville, MOBuilt 1967 · S/N 17256125 N3226LStammen Dakota J · Stanley, NDBuilt 1967 · S/N 17256126 N3227JCanepa Joseph H · Baraboo, WIS/N 15065927 N3227LLown Robin F · Douglas, AKBuilt 1967 · S/N 17256127 N3228LWoodson Marcus L · Detroit, MIBuilt 1967 · S/N 17256128 N3229LTate Samuel Paul Baylon · Tacoma, WABuilt 1967 · S/N 17256129 N3229NArnold Joe · Thermopolis, WYBuilt 1946 · S/N 22421 N322GRHayes Randal E · Jefferson, IABuilt 2023 · S/N 11069 N322TNExecutive Wings LLC · Bolivar, TNBuilt 1972 · S/N 15073812 N3230JEastside Aero Inc · Eatonville, WABuilt 1966 · S/N 15065930 N3230KMoore Michael C · Brooklyn, MIS/N 1223 N3231AStafford Robert H · Orlando, FLBuilt 1953 · S/N 25875 N3231LColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1967 · S/N 17256131 N3231VDariz Natascha Y · Mount Laurel, NJFirst renewal noticeBuilt 1974 · S/N 15076431 N3232AKnutson Daniel T · Lodi, WIBuilt 1953 · S/N 25876 N3232KEastern Stearman Inc Trustee · Leesburg, VABuilt 1946 · S/N 1225 N3232XBitikofer Brent E · Kansas City, KSBuilt 1966 · S/N 15064632 N3233AWalser Kyle · Midwest City, OKBuilt 1953 · S/N 25877 N3233NSvoboda Patrick J · Bucyrus, KSBuilt 1946 · S/N 22424 N3233XNollau Gregory P · Big Bear City, CABuilt 1966 · S/N 15064633 N3234ARobold Andrew D · Redmond, ORBuilt 1953 · S/N 25878 N3235KRacoon Aviation LLC · San Antonio, TXBuilt 1946 · S/N 1228 N3236ALibby Stephen Trustee · Anchorage, AKBuilt 1953 · S/N 25880 N3236JWoehler Keith A · Bardstown, KYBuilt 1966 · S/N 15065936 N3236LMartin Alan K · Tenaha, TXBuilt 1967 · S/N 17256136 N3236XBentch James R · Lincoln, MOBuilt 1966 · S/N 15064636 N3237LKeith Investments LLC · Verona, MSBuilt 1967 · S/N 17256137 N3237VTreetop Flying Circus LLC · Niceville, FLBuilt 1974 · S/N 15076434 N3237XRobinson Michael D · Folkston, GABuilt 1966 · S/N 15064637 N3238JHolladay Harold · Lamesa, TXS/N 15065938 N3238XHorsager Phillip C · Montevideo, MNBuilt 1966 · S/N 15064638 N3239LGame Composites Flying Club · Bentonville, ARBuilt 1967 · S/N 17256139 N323LCBroussard Logan M · Youngsville, LABuilt 2016 · S/N AL-1207 N323LULetourneau University · Longview, TXBuilt 1968 · S/N 15068776 N323SQStainback Horace Jr · Concord, NCBuilt 2006 · S/N 601-009S

Back to AD 94-05-05 R1