Skip to content

Registered aircraft · 22,413

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

N521CWCentral Washington Univ · Ellensburg, WABuilt 2017 · S/N 2843922 N521DHPenner Ford Aviation LLC · Lebanon, MOBuilt 1965 · S/N 28-21007 N521XPalmetto Aces Flying Club LLC · Hilton Head Island, SCBuilt 1978 · S/N 28-7911038 N5220LR & J Services LLC · Tracy, CABuilt 1967 · S/N 28-4513 N5220THammond Michael R · Tigard, ORS/N 28-7225360 N5221LVeritable Solutions LLC · Bremerton, WABuilt 1967 · S/N 28-4514 N5221NBoardman Brian J · Claremont, NHS/N 2843429 N5221S3a LLC · Trussville, ALS/N 32-40915 N5221WGrady John M · Perham, MNBuilt 1961 · S/N 28-258 N5223TBarnard Kevin D · Columbia Station, OHBuilt 1972 · S/N 28-7225362 N5223WStover Jeffrey Wayne · Gastonia, NCBuilt 1961 · S/N 28-260 N5224LWight John M · Merrimack, NHBuilt 1967 · S/N 28-4518 N5224TPerkins Barber Shop · Jennings, LABuilt 1972 · S/N 28-7205248 N5225THolt Joseph · Farmington, MOBuilt 1972 · S/N 28R-7235199 N5226LVancura Aviation LLC · Seffner, FLBuilt 1967 · S/N 28-4520 N5227LPeter David A · Anderson, INBuilt 1967 · S/N 28-4521 N5228LWilliam C New Aviation Services LLC · Morgan City, LAS/N 28-4522 N5229SInk International Inc · Lawrenceville, GABuilt 1970 · S/N 32-40933 N5229TParker Edward Milton Jr · Griffin, GABuilt 1972 · S/N 28R-7235002 N522FLRegistration Pending · Teaneck, NJRegistration pendingBuilt 1971 · S/N 28-7125347 N522JDFly Around Alaska LLC · Palmer, AKBuilt 1970 · S/N 28-26468 N522JWLong Island Aviators LLC · Seaford, NYBuilt 2001 · S/N 2843461 N522MMSaratoga Aviation Inc · Charleston, SCBuilt 1980 · S/N 32R-8013001 N5231KThree One Kilo LLC · Austin, TXBuilt 1978 · S/N 28-7990042 N5231WErikson Nils S · Longview, TXBuilt 1962 · S/N 28-269 N52326Lehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 2001 · S/N 2843450 N5232LRodway George W · Aurora, ORBuilt 1967 · S/N 28-4526 N5232TCampbell Ronald W · Waller, TXBuilt 1972 · S/N 28-7225363 N5233LFox Two LLC · Camino, CABuilt 1967 · S/N 28-4527 N5233TBoots Larry C · Weiser, IDBuilt 1972 · S/N 28-7205249 N5234LDileo Dale · West Islip, NYBuilt 1967 · S/N 28-4528 N5235BBrit Ltd · Wilmington, DEBuilt 2001 · S/N 3257222 N5235LJones Scott M · Overton, NVBuilt 1967 · S/N 28-4529 N5237LAir Sicko LLC · Albany, NYBuilt 1967 · S/N 28-4531 N5237TCavins Drew A · Jacksonville, FLBuilt 1972 · S/N 28-7225366 N5238LBreon Ryan L · Castroville, TXBuilt 1967 · S/N 28-4533 N5238WMckibben Clint E · Lubbock, TXS/N 28-278 N5239LWilson Ronald A · Elk Grove, CABuilt 1967 · S/N 28-4534 N5239TBrotherton Bradley T Trustee · Canby, ORBuilt 1972 · S/N 28-7225368 N523AFVee Two Inc · Merritt Island, FLBuilt 2021 · S/N 28020050 N523BCSaman Beshoy · Round Rock, TXS/N 28-565 N523BHColvin Buster · Big Cabin, OKBuilt 1978 · S/N 28-7816546 N523CDOswald Brandon M · Chesapeake, VABuilt 1975 · S/N 32-7500027 N523CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843923 N523FLOden Matthew E · Greenwood, SCBuilt 1971 · S/N 28-7125349 N523PUMetro Aircraft Co · Bloomington, MNBuilt 1989 · S/N 2841188 N5240TRegistered aircraftBuilt 1972 · S/N 28-7225369 N5240WVanni Steven J · Naples, FLBuilt 1962 · S/N 28-281 N5241LFour One Lima Inc · Roanoke, VABuilt 1967 · S/N 28-4536 N5242LSimpson Jacob William · Crescent Springs, KYBuilt 1967 · S/N 28-4537

Back to AD 87-08-08 R3