Skip to content

Registered aircraft · 85,616

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N12898Nova Ivan · Hackensack, NJS/N 17262353 N12899Lyon Kimberly J · Layton, UTBuilt 1973 · S/N 17262354 N1289DAeronautical Technical Service Inc · Collierville, TNS/N 19865 N1289RLeblanc Rick M · Deerwood, MNBuilt 1972 · S/N 30417 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N1289XConner James B · Mishawaka, INBuilt 1963 · S/N 162 N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354 N128AEChiave Solutions LLC · Orlando, FLBuilt 1981 · S/N E-1830 N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218 N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080 N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128DPGherebi Belaid A · San Diego, CAS/N 28-7125293 N128ESturges John A · Hayden, IDBuilt 1966 · S/N 1190 N128EEAlgab Holdings LLC · Newark, DEBuilt 1978 · S/N P21000133 N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806 N128HBSowle LLC · Tampa, FLBuilt 2007 · S/N 3257479 N128HRDerenick Aviation LLC · Aguadilla, PRS/N 17262679 N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785 N128KJm Lavore Aero Inc · Lakeside, MTBuilt 1961 · S/N TD-488 N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132 N128MAFca Flight Center Inc · Fitchburg, MABuilt 1975 · S/N 17263941 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074 N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171 N128PBHayes Thomas G · Kerrville, TXBuilt 1966 · S/N 1283 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N128SWRegistered aircraftBuilt 1966 · S/N 18051699 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991 N128WMOac Aviation LLC · Asheville, NCBuilt 1997 · S/N E3115 N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579 N128WSSkyway Air Taxi LLC · Manassas, VABuilt 2001 · S/N TH-1982 N128XHaynes Bruce A · Welches, ORBuilt 1951 · S/N D-2818 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N1290HWeiss Gregory K · Manitou Springs, COS/N 28-7716012 N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650 N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275 N1290XJr Aviation LLC · Benton, KSBuilt 1963 · S/N 163 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276 N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573 N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292DKlaerner John D · San Antonio, TXBuilt 1951 · S/N 19868 N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668

Back to AD 98-21-21 R1