Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039 N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924 N961AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12154 N961LCSanpete Aviation LLC · Nephi, UTS/N 17250480 N961LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12031 N9621VHathor Aviation LLC · Johnstown, COBuilt 1974 · S/N 17264401 N96227Civil Air Patrol Inc · Montgomery, ALBuilt 1983 · S/N 17276045 N9622HSanders Flight Training Center LLC · Jasper, ALBuilt 1975 · S/N 17266272 N9622QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265707 N9623VSchreder Peter T · Joseph, ORS/N 17264403 N9625QMars Aerospace Inc · Bay Shore, NYBuilt 1975 · S/N 17265709 N9625VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 17264405 N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927 N9626HRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 17266274 N9626QChambers Matthew A · Tehachapi, CABuilt 1975 · S/N 17265710 N9627HSuperbuyer Inc · San Jose, CABuilt 1975 · S/N 17266275 N9628HT3 Aerosports LLC · Vian, OKBuilt 1975 · S/N 17266276 N96299Djm Aviation LLC · Rhome, TXS/N 17276054 N962AUAuburn University · Auburn, ALBuilt 2019 · S/N 172S12292 N962LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12032 N962SHObermeier Scott D · Manchester, CTBuilt 1961 · S/N 17248864 N9630QKelley Aircraft LLC · Weyers Cave, VABuilt 1975 · S/N 17265714 N9630VN275508 LLC · Margate, FLBuilt 1974 · S/N 17264410 N9631BPercy Flyers LLC · Dexter, MIBuilt 1981 · S/N 172RG0930 N9631QHuntsman Ferral Don · Juneau, AKBuilt 1975 · S/N 17265715 N9631VHarrold Bruce E · Greybull, WYBuilt 1974 · S/N 17264411 N9632HSweitz-Air Inc · Stewartstown, PAS/N 17266279 N9633HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266280 N9634QDubois County Flight Services Inc · Huntingburg, INBuilt 1975 · S/N 17265718 N9635BFisher Frank L · San Diego, CABuilt 1981 · S/N 172RG0933 N9635HArizona Aircraft Leasing LLC · Mesa, AZBuilt 1975 · S/N 17266282 N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592 N9635QRozynski Jason K · Malabar, FLBuilt 1975 · S/N 17265719 N9635V35 Victor LLC · Decatur, GABuilt 1974 · S/N 17264415 N9636HMontanez Orlando · Guaynabo, PRBuilt 1975 · S/N 17266283 N9636VNaperville Flying Club · Woodridge, ILBuilt 1974 · S/N 17264416 N9637QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265721 N9638HHatbright Farm LLC · Wilmington, DEBuilt 1975 · S/N 17266285 N9638QPeterson John E · Benton, KSBuilt 1975 · S/N 17265722 N9638VCrazy Aces LLC · St George, UTBuilt 1974 · S/N 17264418 N963ACYoung Paul J · Hudson, MABuilt 1999 · S/N 172S8259 N963AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12478 N963EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13007 N963JADeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10521 N963KMMiller Karl E Trustee · Chandler, AZBuilt 1974 · S/N 17264198 N963LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12033 N963SPAero Aircraft 11 LLC · Jacksonville, FLBuilt 1999 · S/N 172S8166 N963TASvetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9610 N9640HCorriher Mark B · Mocksville, NCBuilt 1975 · S/N 17266287 N9640VN9640v LLC · Ann Arbor, MIS/N 17264420

Back to AD 90-06-03 R1