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.

N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000 N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845 N329DMMarek James E · Ozark, ALBuilt 1981 · S/N 24-1252 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32BKRagen Caroline Farms LLC · Jonesboro, ARBuilt 1973 · S/N 412-74 N32DHHighgate Aero Inc · Swanton, VTBuilt 2004 · S/N 4542004 N32FDMansfield Stephen K · Boynton Beach, FLS/N 20-1249 N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026 N32JCMelton Charles Robert · Alexandria, VABuilt 1977 · S/N 24-0120 N32LDms Aviation Services LLC · Wildwood, MOBuilt 1991 · S/N 654-91 N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454 N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019 N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862 N3306CSkylane Inc · Schaumburg, ILBuilt 1978 · S/N R18200269 N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498 N3309CScott Parker H · Bulverde, TXBuilt 1978 · S/N R18200270 N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N330MSCanyon Airmotive LLC · Frisco, TXBuilt 1995 · S/N 750-95 N3310TFly448 LLC · Wausau, WIBuilt 1968 · S/N 17700045 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627 N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747 N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920 N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621 N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925 N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930 N3323TDeese James K Jr · Charlotte, NCS/N 17700623 N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932 N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626 N33272Explorco LLC · Evergreen, COBuilt 1976 · S/N 177RG0938 N33273Dahl Neil A · Arlington, TXBuilt 1976 · S/N 177RG0939 N33274Cooker Brian M · Gold Hill, NCBuilt 1976 · S/N 177RG0940 N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224 N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627 N3328ENorthwoods Air LLC · Orono, MES/N 17271505 N33291Skyways Aviation Inc · Wilmington, DEBuilt 1976 · S/N 177RG0944 N33296Mob Aviation USA LLC · Auburndale, FLBuilt 1976 · S/N 177RG0946 N33297Skinner Marvin L · Mansfield, TXBuilt 1976 · S/N 177RG0947 N33299Business Jet Services Inc · Apopka, FLBuilt 1976 · S/N 177RG0948 N332DBFulton Flying Club Inc · North Canton, OHBuilt 1980 · S/N 24-0986

Back to AD 80-25-07 R1