Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N253MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881445 N253RAReynolds Darryl G · Wills Point, TXBuilt 1981 · S/N 17274790 N253SWBatts David · Lyons, COBuilt 1965 · S/N 28-2328 N253TPLeblanc John David · Deland, FLFirst renewal noticeBuilt 1987 · S/N 253 N253WMLambert Timothy Allen Jr · Burleson, TXBuilt 1964 · S/N 28-2026 N253WYMj & Rj LLC · Middletown, DEBuilt 2015 · S/N 3253 N254Russell Dale Christopher · Sierra Vista, AZBuilt 1978 · S/N AA5B0970 N25408Thompson David J · Pemberton, NJBuilt 1977 · S/N 15280637 N2540ASlaton James E · Minot Afb, NDS/N 22-837 N2540CSpeidel Jake P · Carmel, CABuilt 1978 · S/N 38-79A0222 N2540FMcguires Flying Service LLC · Obion, TNBuilt 1965 · S/N 96 N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903 N2540QAmt Aero Inc · Massapequa, NYBuilt 1977 · S/N 28-7790404 N25410Smith Ira · Henderson, NVBuilt 1980 · S/N 38-80A0166 N25413Dreamair Aviation Inc · Boca Raton, FLBuilt 1977 · S/N 15280641 N25416Mikes Aircraft Shop Inc · Corpus Christi, TXBuilt 1977 · S/N 15280643 N2541SLanning Danny E · Alzada, MTBuilt 1979 · S/N 18-7909156 N25426American Aviation Inc · Brooksville, FLBuilt 1977 · S/N 15280651 N2542MHudson Joseph M · Holly Springs, NCBuilt 1946 · S/N 12-1031 N2542ZGreenway Jonathan J · Frederick, MDBuilt 1977 · S/N 344-77 N25430G And M Aircraft Inc · Wheatridge, COBuilt 1977 · S/N 15280654 N2543URegistered aircraftBuilt 1979 · S/N 28-8090055 N2543ZSchindler Jason D · Oneill, NES/N 345-77 N2544MDeaton Mark · Gig Harbor, WAS/N 12-1033 N2544PCoonfield Russell Adam · Fayetteville, ARBuilt 1955 · S/N 22-2907 N2544SSunrise Adventures LLC · Stillwater, MNBuilt 1979 · S/N 18-7909155 N2545CDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496324 N2545MCopenhaver Patrick J · Enumclaw, WABuilt 1946 · S/N 12-931 N2545PMatter Steven S · Joliet, ILFirst renewal noticeBuilt 1955 · S/N 22-2908 N2545UMcmahon Patrick S · San Antonio, TXBuilt 1979 · S/N 28-8016032 N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242 N25467Reynolds Financial Inc · Tyler, TXBuilt 1977 · S/N 15280636 N25469Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280675 N2546CRaby Byrd J · Normandy, TNBuilt 1954 · S/N 26190 N2546GStambaugh Rex E · Westminster, COBuilt 1967 · S/N 421 N2546PDadez Jaime G · Browntown, WIS/N 22-2910 N2546UL00 Fliers LLC · Lewes, DEBuilt 1979 · S/N 28-8016033 N2546ZClark Brent R · Layton, UTBuilt 1977 · S/N 998-77 N2547Sale Reported · Big Bear City, CASale reported, canceledBuilt 1971 · S/N 1 N25471Cottingham Lon W · Kingwood, TXBuilt 1940 · S/N 1 N25476Rf Aero LLC · Plainfield, ILBuilt 1977 · S/N 15280680 N25477Mason Harold T · Hesperia, CAS/N 15280681 N2547DFinley Charles Marcus · Reno, NVBuilt 1978 · S/N 38-79A0366 N2547FAysta Paul M · Embarrass, MNBuilt 1966 · S/N 48 N2547HThree S Ranch · Blanca, COBuilt 1979 · S/N 18-7909198 N2547MCapozzi Tony · Seaford, DEBuilt 1946 · S/N 12-930 N2547QLawrence Thomas C · Memphis, TNBuilt 1977 · S/N 28-7725200 N2547WBittorf Charles Shane · Clear Lake, WIBuilt 1974 · S/N MC-255 N2547ZLecompte Francesca · Lancaster, MABuilt 1978 · S/N 261-78 N25480Freeflight Aviation LLC · Allentown, NJBuilt 1977 · S/N 15280684

Back to AD 90-04-06 R1