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.

N8795BE2 Technologies Inc · Grand Haven, MIBuilt 1957 · S/N 36495 N8796BTetrault Phil H · Chisago City, MNS/N 36496 N8799BUssrey Charles W · Wellston, OKBuilt 1957 · S/N 36499 N879FZDon Davis Aviation Inc · Henderson, KYBuilt 2019 · S/N 172S12403 N879HZMewmew Investment LLC · Palo Alto, CABuilt 2019 · S/N 172S12405 N879LPSpartan National Holdings LLC · Missoula, MTBuilt 2001 · S/N 172S8879 N879MTCfgn Aviation LLC · Molalla, ORBuilt 1997 · S/N 17280063 N879WHHumphrey Ronald D · Pace, FLBuilt 1976 · S/N 17268487 N87DRegistration Pending · Ashville, NYRegistration pendingBuilt 1965 · S/N 17253345 N87FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12950 N87GVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280355 N87HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1998 · S/N 172S8022 N87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1998 · S/N 172S8012 N8800UWright Flight Inc · Tucson, AZBuilt 1965 · S/N 17252706 N8800ZGuest Marc E · Davidsonville, MDBuilt 1966 · S/N 17255450 N8801BWelch Thomas R · Modesto, CAS/N 36501 N8801UBarnett David · Brock, TXBuilt 1965 · S/N 17252707 N8802UWoods Helen · Laurel, MDBuilt 1965 · S/N 17252708 N8803BEisert Stephan William · Mint Hill, NCBuilt 1957 · S/N 36503 N8803UDale David J · North Fort Myers, FLBuilt 1965 · S/N 17252709 N8804UParadox Investments Pacnw LLC · San Antonio, TXBuilt 1965 · S/N 17252710 N8804ZPoorboy Flying Club LLC · Erick, OKFirst renewal noticeBuilt 1966 · S/N 17255454 N8806ZFrancechi Marc Anthony · Phoenix, AZBuilt 1966 · S/N 17255456 N8807BLee Kendall Nathan · Madras, ORS/N 36507 N8808UValiair Limited Company Trustee · Casper, WYS/N 17252715 N8809BEagles Wings Inc · San Angelo, TXBuilt 1957 · S/N 36509 N880AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13537 N880CBJ-Airco LLC · Nashville, TNBuilt 1973 · S/N 17262582 N880EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12807 N880THAviation Peter Corp Of New York · New York, NYBuilt 1980 · S/N 172RG0522 N880WSDepartment Of Inland Fisheries And Wildlife · Greenville, MEBuilt 2015 · S/N 172S11661 N8810UWebesharing LLC · Orange Beach, ALBuilt 1965 · S/N 17252717 N8811BMatty Elizabeth · Tucson, AZBuilt 1957 · S/N 36511 N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718 N8813UAerios Air LLC · Midland, TXBuilt 1965 · S/N 17252720 N8813ZDuman Adrianna A · Los Angeles, CABuilt 1966 · S/N 17255463 N8814BEvans Roy L · Winnemucca, NVBuilt 1957 · S/N 36514 N8815BWiser Kurtis · Kennewick, WAS/N 36515 N8815ZAerowood Aviation LLC · Monroe, NCBuilt 1966 · S/N 17255465 N8816UHocus Holdings LLC · Carrollton, OHBuilt 1965 · S/N 17252723 N8817ZRegistration Pending · Redmond, WARegistration pendingS/N 17255467 N8818BFairfield Eugene D · Wiscasset, MEBuilt 1957 · S/N 36518 N8818TEngel Samina · San Diego, CABuilt 1964 · S/N 17251521 N8818UUfford Christian T · Vershire, VTBuilt 1965 · S/N 17252725 N8819UBoss Gary W · Bronston, KYBuilt 1965 · S/N 17252726 N881ACFly Twin Comanche LLC · Peoria, AZBuilt 2001 · S/N 172S8818 N881LAAircraft Holdings LLC · Mesa, AZBuilt 2020 · S/N 172S12607 N881WABlahut Robert John · Prosser, WABuilt 1968 · S/N 17257390 N8821UEuros Aircraft Leasing LLC · College Station, TXBuilt 1965 · S/N 17252729 N8822BDalton James B · Wells, NVBuilt 1957 · S/N 36522

Back to AD 90-06-03 R1