Skip to content

Registered aircraft · 81,733

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N3604LWalker Carol L · Ennis, TXBuilt 1978 · S/N 0812 N3604MKelsey Mike O · Carey, IDBuilt 1947 · S/N 12-2453 N3604PRegistration Pending · League City, TXRegistration pendingBuilt 1955 · S/N 22-3327 N3604XJones Bryan David Kingsley · San Diego, CABuilt 1977 · S/N 0767 N36052Icarus Flying Academy LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816608 N36056Cleared Aviation LLC · Novato, CABuilt 1978 · S/N 28-7816609 N3605HChilders Matthew W · Scottsdale, AZBuilt 1977 · S/N 20-1242 N3606EMiller Robert J · Casselton, NDBuilt 1978 · S/N 17271604 N3606MStuart B Stephens Dds Ms Plc · Yukon, OKBuilt 1978 · S/N 28-7890277 N3606ZLandreth Homer W · Peoria, AZBuilt 1960 · S/N 22-7494 N36071Aero Systems Consultants Inc · Tulsa, OKBuilt 1978 · S/N 32R-7885155 N36077Coffey Diane L · Chuckey, TNBuilt 1978 · S/N 28-7890492 N3607AMassey William R · Alturas, CABuilt 1953 · S/N 22-1867 N3607EPalm Cedric C · St Francisville, LABuilt 1978 · S/N 17271605 N3607MWick Air Inc · Palmer, AKBuilt 1947 · S/N 12-2516 N3607QToole William Barry · Goochland, VABuilt 1967 · S/N MA-207 N3607WOceanstate Flying Club Inc · Little Compton, RIBuilt 1966 · S/N 32-506 N3607XAldrich Roy · Webster, SDS/N 5081 N3608MRoman Peter A · Aurora, ILBuilt 1978 · S/N 28-7816359 N3608WHand Andy A · Waco, TXBuilt 1966 · S/N 32-507 N3608ZBingman William A · Depoe Bay, ORBuilt 1960 · S/N 22-7496 N36094Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1978 · S/N 28-7816612 N36095Wiese Robert M · Washburn, NDBuilt 1978 · S/N 28-7890494 N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265 N3609EBismarck Aero Center Corp · Bismarck, NDBuilt 1978 · S/N 17271606 N3609MKosbruk Patrick E · Perryville, AKBuilt 1978 · S/N 28-7816360 N3609WConverse James Robert · Port Saint Lucie, FLBuilt 1966 · S/N 32-509 N3609ZVeal Petra L · Sterling, AKBuilt 1960 · S/N 22-7497 N360AJAngle Of Attack LLC · Waynesville, OHS/N 25089 N360AMAhlgren Jon E · Juneau, AKBuilt 2015 · S/N 104M N360BBWhittier Lavoy A Bucky · Twin Falls, IDBuilt 2000 · S/N 708-320-552FB N360BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881913 N360BHRybczynski Douglas R · Chandler, AZBuilt 1995 · S/N 001 N360BJCode Supplies Inc · Rossville, TNBuilt 2026 · S/N PA 206 N360BKBerkut Environmental Consulting LLC · Raleigh, NCBuilt 2009 · S/N 034 N360BSChampagne Patrick D · San Angelo, TXBuilt 1959 · S/N 18-6869 N360CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281519 N360CRFree Man Airshows Ltd · Lyons, COS/N 865-320-662 N360DPSiebert Mcmahon LLC · Kalispell, MTBuilt 1994 · S/N 20084 N360ECdw Flyers LLC · Kinnelon, NJBuilt 2022 · S/N 18283198 N360EMAg Flyers Inc · Torrington, WYBuilt 1994 · S/N 20916 N360ESEdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280010 N360FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020060 N360GJYoung Matthew · Conroe, TXBuilt 1995 · S/N 21735 N360GLLaznicka Garry V · Saint Charles, MOS/N 974-320-814CSFB N360GMMcdaniel Gary D · Kansas City, MOBuilt 1996 · S/N 3492 N360GTBrannigan Vanessa D · Morganton, NCBuilt 1995 · S/N 688-320-432FB N360HCMountain Air Spray Co Inc · Craig, COBuilt 1952 · S/N 18-1868 N360HUParker John J · Hamilton, MTBuilt 1996 · S/N 1341 N360JRahz Caleb G · Cuyahoga Falls, OHBuilt 1996 · S/N 774-320-616 FB

Back to AD 81-18-04 R2