Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N201NUGolden Seal Enterprises Inc · Winchester, VABuilt 1977 · S/N 24-0277 N201NVSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 24-0294 N201NWBravo Echo LLC · Eagan, MNBuilt 1977 · S/N 24-0276 N201NXSzajer Gregory · Catskill, NYBuilt 1977 · S/N 24-0283 N201NZMooney M20j Brokers LLC · Saint Charles, MOBuilt 1977 · S/N 24-0300 N201PMarshall Christopher R · Oshkosh, WIBuilt 1976 · S/N 240070 N201PBHumphrey Richard Ingraham · Keller, TXBuilt 1977 · S/N 24-0146 N201PCGreatest Show Management LLC · Bee Cave, TXBuilt 1977 · S/N 24-0083 N201PDOlmstead Cecil Jay III · Houston, TXBuilt 1977 · S/N 24-0170 N201PFMooney Flyers LLC · Minot, NDBuilt 1977 · S/N 24-0145 N201PJBrownfield Izzy · Denton, TXBuilt 1977 · S/N 24-0180 N201PKMininger John · Quakertown, PABuilt 1977 · S/N 24-0278 N201PLM Star Aviation LLC · Oconto, WIBuilt 1977 · S/N 24-0284 N201PNAkins Anthony · Meridian, IDBuilt 1977 · S/N 24-0302 N201PPRohrbach James S · Fort Lauderdale, FLBuilt 1979 · S/N 24-0846 N201PQBlue Steel Ventures LLC · Wilmington, NCBuilt 1977 · S/N 24-0287 N201PSEmbrey Matthew D · Murrieta, CABuilt 1977 · S/N 24-0113 N201PTWells Tony · Knob Lick, KYBuilt 1977 · S/N 24-0106 N201PVCowan George L · Scranton, SCBuilt 1977 · S/N 24-0321 N201PXNecessary Richard A Jr · Rural Hall, NCBuilt 1977 · S/N 24-0315 N201PYRandolph Paul D · Easley, SCS/N 24-0310 N201PZSmits Joel R · Crete, ILBuilt 1977 · S/N 240329 N201QAIron Wing Flying Club Inc · Shelby Township, MIBuilt 1977 · S/N 24-0317 N201QBQuattlebaum Kevin R · High Rolls, NMBuilt 1979 · S/N 240895 N201QCDigital Outdoor Adertising LLC · Reno, NVS/N 24-0305 N201QEWaters Michael C · Social Circle, GABuilt 1977 · S/N 24-0343 N201QHPodd Bradley Stephen · Wilmington, NCBuilt 1977 · S/N 24-0348 N201QJDubritz Michael J · Dix Hills, NYBuilt 1977 · S/N 24-0347 N201QLBuchholz Michael S · West Hamlin, WVBuilt 1986 · S/N 24-1604 N201QMNordica Group Ltd · Chicago, ILBuilt 1977 · S/N 24-0339 N201QRJennings Denise E Trustee · Fullerton, CABuilt 1977 · S/N 24-0353 N201QSLaughridge Mark L · Apopka, FLBuilt 1977 · S/N 24-0325 N201QTR Squared LLC · Brandon, MSBuilt 1977 · S/N 24-0309 N201QUModen Aircraft Inc Trustee · Wilmington, DEFirst renewal noticeBuilt 1991 · S/N 243216 N201QVJohnson Philip H · Bluffton, SCS/N 24-0355 N201QWRose James D · Fort Worth, TXS/N 24-0236 N201QXRegistration Pending · Portland, ORRegistration pendingBuilt 1977 · S/N 24-0367 N201QYJohnson Seth M · Arlington, TXBuilt 1977 · S/N 24-0357 N201QZFogle Adventure Air LLC · Neeses, SCS/N 24-0358 N201RMay Jack C · Conroe, TXBuilt 1977 · S/N 24-0203 N201RAMooney 201ra Holding LLC · San Diego, CABuilt 1982 · S/N 24-1319 N201REFowler W Kirk · Longmont, COBuilt 1977 · S/N 24-0341 N201RFMfc Corp · Washington, DCS/N 24-0135 N201RGCrate Thomas Trustee · Las Vegas, NVBuilt 1989 · S/N 24-3138 N201RJLoyless John B · Lubbock, TXBuilt 1977 · S/N 24-0115 N201RLGmg Associates · Madison, CTBuilt 1977 · S/N 24-0143 N201RPLanter Patricia Diane · Camarillo, CABuilt 1992 · S/N 24-3255 N201RRGuthrie Edward J · Lincoln Univ, PABuilt 1977 · S/N 24-0089 N201RSWilliams Ken L · Palmer, AKBuilt 1976 · S/N 24-0062 N201RTRed Tail Av8rs LLC · Saline, MIS/N 24-1109

Back to AD 80-25-07 R1