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.

N5295THayley Douglas Aviation Inc · Auburn, ALFirst renewal noticeBuilt 1972 · S/N 32-7240104 N5297LIndulgences Inc · Putnam Valley, NYBuilt 1968 · S/N 28-4599 N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396 N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349 N5299LSerafini Ronald S · Murphy, NCS/N 28-4601 N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744 N529CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843925 N529DARegistration Pending · Travis Afb, CARegistration pendingBuilt 2020 · S/N 2881423 N529ECAlpha Tango LLC · Little River, SCBuilt 1975 · S/N 32R-7680072 N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356 N529KMSmtm Holdings Inc · Wilmington, DES/N 28R-7435196 N529KSJohnson Greg L · Stamping Ground, KYS/N 32R7780472 N529RGKarger Kenneth · Graford, TXBuilt 2005 · S/N 3255031 N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450 N52CLDannebrog Air LLC · Grand Island, NEBuilt 1971 · S/N 28R-7135042 N52HWBurns Robert B · Placerville, CABuilt 1966 · S/N 28-3466 N52KCTlc Developments LLC · Sheridan, WYBuilt 1980 · S/N 28R-8031169 N52RWWorland Flying Club LLC · Worland, WYBuilt 1973 · S/N 28-7305341 N52TCVig Charles R · Prior Lake, MNBuilt 2000 · S/N 3257185 N5300LUrgell Michael N · Trophy Club, TXBuilt 1968 · S/N 28-4602 N5300UEden Mark A · Weirsdale, FLBuilt 1964 · S/N 28-20235 N5301LSpagway Aviation Corp · Divide, COBuilt 1968 · S/N 28-4603 N5301TTanner Fred K · Tuscaloosa, ALBuilt 1972 · S/N 28R-7235222 N5304LBryant Christopher P · Montpelier, OHBuilt 1968 · S/N 28-4606 N5305LStearns Simon K · Edwardsville, ILBuilt 1968 · S/N 28-4607 N5306LRusch Steven A · Sequim, WABuilt 1968 · S/N 28-4608 N5308LNelson John · Wichita, KSBuilt 1968 · S/N 28-4610 N5309LTexasflight3000 Holdings LLC · Crossroads, TXBuilt 1968 · S/N 28-4611 N530MCMagic Carpet LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235258 N530PUConrad Brian Michael · Pasadena, MDBuilt 1989 · S/N 2837038 N5311LKitko Stephen D · Bellefonte, PABuilt 1968 · S/N 28-4614 N5311TSchrier Timothy M · Savage, MNBuilt 1972 · S/N 28-7225397 N5313WWoodard Milton · Ripley, TNBuilt 1962 · S/N 28-367 N5314LGormley Laurie A · Las Cruces, NMS/N 28-4616 N5314WRasler Christopher · Puyallup, WABuilt 1962 · S/N 28-369 N5315LTorres Daniel A · Baldwin, NYBuilt 1968 · S/N 28-4617 N53189Naylor Irvin H Jr · Charlotte, NCBuilt 2001 · S/N 2843434 N5318LWing Timothy R · Raleigh, NCBuilt 1968 · S/N 28-4620 N5318TSmith Stephan R · Morrisville, PABuilt 1972 · S/N 28-7225398 N5319AN5319a Corp Trustee · Wilmington, DES/N 2843435 N5319JSouthwinds Export Inc · Kissimmee, FLS/N 3257213 N5319MPaphos Airways LLC · Farmingdale, NYS/N 2842122 N5319SCampo Jonathan Ibarra · Lakeland, FLBuilt 1970 · S/N 28-26831 N5319XMeadowlake Aviation LLC · Lenoir City, TNS/N 2842119 N531AMcs Aviation LLC · Wetumpka, ALBuilt 2000 · S/N 32-57160 N531AAAirsmart Aviation Academy LLC · Las Vegas, NVBuilt 1980 · S/N 28R-8018098 N531BMJ&V Sky LLC · West Covina, CABuilt 1979 · S/N 28-7990510 N531GSNance Timothy Hunter · Advance, NCBuilt 1977 · S/N 28R-7837019 N531MGN422pj LLC · Missoula, MTBuilt 1999 · S/N 2843260 N531NABlue Skies Leasing Inc · Port Orange, FLBuilt 1977 · S/N 28-7790414

Back to AD 87-08-08 R3