Skip to content

Registered aircraft · 20,683

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.

N4877JR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273687 N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384 N487ERCloudchasers LLC · Colorado Springs, COS/N 172S10547 N487MTGilmore Bobby Keith · Swifton, ARBuilt 1958 · S/N 46040 N487SPArchimedes Aviation LLC · Livermore, CABuilt 2001 · S/N 172S8765 N4880FFkm Air Shuttle LLC · Brooklyn, NYBuilt 1979 · S/N 17273095 N4880GCifelli George J · Dothan, ALFirst renewal noticeBuilt 1979 · S/N 17273427 N4881EFulltron Aviation LLC · Springfield, MOBuilt 1978 · S/N 17271672 N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430 N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386 N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432 N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433 N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434 N4888G578 Airplane Leasing Inc · Kissimmee, FLS/N 17273435 N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387 N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436 N488BAPlane Nonsense Inc · Middletown, DES/N 17273345 N488EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12256 N488JWKagey David M · Seabrook, TXBuilt 1972 · S/N 17261113 N488WMMackey Ken G · Ridgeville, SCS/N 36266 N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691 N4893ELjl & D Inc · Wilmington, DEBuilt 1978 · S/N 17271673 N4893GBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17273440 N4893JMartineau Aircraft Inc · Butte, MTBuilt 1979 · S/N 17273692 N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442 N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410 N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443 N4896MSmtm Holdings Inc · Wilmington, DEBuilt 1981 · S/N 17274294 N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411 N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674 N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444 N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097 N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446 N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443 N489ECRobertson James T · Forest Lake, MNBuilt 1964 · S/N 17251278 N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083 N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064 N48EFVista Air Inc · Pacoima, CABuilt 2004 · S/N 172S9629 N48FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12875 N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312 N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693 N48RGBlueskies LLC · Smyrna, TNBuilt 2023 · S/N 172S12953 N4900DCastaneda Jose · Yakima, WAS/N 17272389 N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099 N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451 N4908GShaffer Aviation LLC · Tupelo, MSS/N 17273455 N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456 N490EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12258 N490NWGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2021 · S/N 172S12757 N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031

Back to AD 90-06-03 R1