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.

N4182WNovember Four One Eight Two Whiskey LLC · Fulton, MOBuilt 1967 · S/N 32-40264 N41838Baker Arthur M II · Mundelein, ILBuilt 2000 · S/N 3246171 N4183DChallenge Aviation · Orange, CAS/N 3257203 N4183WTate Aviation LLC · Camden, DEBuilt 2000 · S/N 3257183 N41847Saratoga N41847 LLC · Wilmington, DES/N 32-57165 N4184JGorman Jeffrey M · Ellensburg, WAS/N 28-22523 N4184MG&M Aircraft Inc · Wheat Ridge, COBuilt 2001 · S/N 2844062 N4184RB&S Air LLC · Palm City, FLBuilt 1968 · S/N 32-40517 N4184TMullys Equipment Leasing LLC · Castle Pines, COBuilt 2001 · S/N 2843418 N4184VUpper Jets Maintenance LLC · Miami, FLBuilt 2001 · S/N 2843420 N4184XM&N Aviation LLC · Carolina Beach, NCBuilt 2001 · S/N 3257200 N41858Skybound Aviation LLC · Kernersville, NCBuilt 1974 · S/N 28-7415338 N41859Morale Joseph D · Dallas, TXBuilt 1974 · S/N 28-7405145 N4185WJames William S · Orange Park, FLBuilt 2001 · S/N 2843417 N4185XWjw Transport Inc · Hampshire, ILBuilt 2000 · S/N 3257195 N41862Shutter Up Aviation LLC · Lake Clarke Shores, FLS/N 3246178 N41866Racy Equipment Leasing LLC · Tucson, AZBuilt 2000 · S/N 3257177 N41867Stevens Charles O · Columbus, MSBuilt 1974 · S/N 28-7415340 N4186N86 Aviation LLC · Katy, TXS/N 2843411 N4187DArthur Robert · Redlands, CAS/N 3257197 N4187HMcalister Aviation LLC · Greenwood, ARBuilt 2000 · S/N 3257196 N4187JPeterson Erik J · Revillo, SDBuilt 1967 · S/N 28-22526 N4187QAggie80 Air LLC · Richmond, TXBuilt 2001 · S/N 3257214 N4187RAnkrum Donald Larry · Hemet, CABuilt 1968 · S/N 32-40522 N41880Brown Terry K · Eddyville, IABuilt 1974 · S/N 28-7425292 N41882Monroe Robert E · Navarre, FLBuilt 1974 · S/N 28-7415345 N41888Lanyi Clifford M · Attleboro, MABuilt 1974 · S/N 28-7415348 N4188HAir Thacker LLC · Wilmington, DES/N 3246181 N4188TBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843124 N41896Hoffman Rick · Buckley, WABuilt 1974 · S/N 28-7415349 N41897Unlimited Upside LLC · Boggstown, INBuilt 1974 · S/N 28-7415350 N4189APelton Ag Inc · Burdett, KSBuilt 2003 · S/N 3255007 N4189RFarr Fly LLC · Wilmington, DEBuilt 1968 · S/N 32-40525 N418FLKinney Richard · West Des Moines, IABuilt 1971 · S/N 28-7125197 N418PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843414 N418TJFive Star Family Aviation LLC · Yorkville, ILBuilt 1977 · S/N 28-7890086 N41901Specht Gilbert E · Downs, KSBuilt 1974 · S/N 28-7405148 N41903Adverse Yaw Corp · Hillsborough, NJBuilt 1974 · S/N 28R-7435224 N41904Gjertsen John W · Quincy, CABuilt 1974 · S/N 28-7425294 N41905Rodgers Phillip L · Williford, ARBuilt 1974 · S/N 28-7415353 N4190E4190e LLC · Tucson, AZBuilt 2000 · S/N 3257172 N41911West Bend Air Inc · West Bend, WIBuilt 1974 · S/N 28R-7435226 N4191JVillalba Raymond · Katy, TXBuilt 1966 · S/N 28-22531 N4191WHowell Bo L · New Sharon, IABuilt 1967 · S/N 32-40276 N41927Budziejko David C · Williamsville, NYBuilt 1974 · S/N 28-7415360 N4192WPeters Karen L · Wanatah, INBuilt 1967 · S/N 32-40277 N41937Calumet Aero LLC · Crown Point, INBuilt 1974 · S/N 28-7415365 N4193WTurk Gerald L · Victor, MTBuilt 1967 · S/N 32-40279 N41940Moughty Matthew · New Haven, VTS/N 28R-7435228 N41949Ferg Robert B · New London, WIBuilt 1974 · S/N 28-7425301

Back to AD 87-08-08 R3