Skip to content

Registered aircraft · 22,416

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.

N8515NCarolina Xl Aviation LLC · Fort Mill, SCS/N 28-7305235 N8515WAviablu Inc · Pembroke Pines, FLBuilt 1963 · S/N 28-10016 N8516FFarley Gail A · Elizabethtown, PABuilt 1976 · S/N 28-7715276 N8516NPakiz Patrick A · Siren, WIBuilt 1970 · S/N 28-11310 N8516WWings Level Flying Club · Mechanicsville, VAS/N 28-10017 N8517WHolcomb John M · Wellington, TXBuilt 1963 · S/N 28-10018 N8519WGary Michael J · Dover, OHBuilt 1963 · S/N 28-10020 N851AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881850 N851PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843942 N851PUTrustees Of Purdue University · West Lafayette, INS/N 2881324 N851VLBlue Waters Air Charters LLC · San Juan, PRS/N 32-7700009 N851WTFowler Clinton Lewis · Conroe, TXBuilt 1976 · S/N 28-7790077 N8520NFriedman Steven J · Jacksonville, FLBuilt 1969 · S/N 28-11318 N8520WHunsaker Jerry Dean · Corpus Christi, TXBuilt 1963 · S/N 28-10021 N8521NRide Solutions Inc · Sudan, TXBuilt 1969 · S/N 28-11319 N8522WBarkley William T · Westlake Village, CABuilt 1963 · S/N 28-10023 N8523NDonahoe Ronald C · Ash Flat, ARBuilt 1969 · S/N 28-11322 N8524EN9278w LLC · Orange, CABuilt 1976 · S/N 28-7610086 N8524NEt Aviation LLC · Cambria, CABuilt 1969 · S/N 28-11323 N8524WAnchor Aviation LLC · Lester Prairie, MNBuilt 1963 · S/N 28-10025 N8525NBurwell Brent C · Madera, CABuilt 1969 · S/N 28-11324 N8526FMinton Gabriel D · Wexford, PABuilt 1976 · S/N 28-7715279 N8526NKing Fitzwilliam W Jr · Marietta, SCBuilt 1969 · S/N 28-11325 N8527NEsterly John P · Wernersville, PABuilt 1969 · S/N 28-11326 N8527WBrigmond Christopher · Ambrose, GABuilt 1963 · S/N 28-10028 N8528CJain Abhishek · Weehawken, NJBuilt 1976 · S/N 28-7615115 N8528WPark Derek B · Lyons, GABuilt 1963 · S/N 28-10029 N852DXGlobe Aero LLC · Lakeland, FLBuilt 2025 · S/N 2881900 N852PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843943 N852PUTrustees Of Purdue University · West Lafayette, INS/N 2881325 N852VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 32-7400003 N8530NGood Curvin M · Memphis, MOBuilt 1969 · S/N 28-11329 N8531NCaltrider Joseph S · Williamstown, WVBuilt 1969 · S/N 28-11330 N8532NNiederberger Edgar C · Idaho Falls, IDBuilt 1969 · S/N 28-11331 N8532WSorby Kyle · Fort Ransom, NDBuilt 1963 · S/N 28-10033 N8534NVilar Mitch · Brookfield, WIBuilt 1969 · S/N 28-11333 N8535EAmerican Compressor Flight Inc · Santa Fe Springs, CABuilt 1976 · S/N 32R-7680150 N8535NJeffrey Robert Hudson · Bakersfield, CAS/N 28-11334 N8536NMcmath Robert · Seeley Lake, MTS/N 28-11335 N8536WFeather Inc · Clarksdale, MSBuilt 1963 · S/N 28-10037 N8537WGone With The Wind LLC · Sturgis, SDBuilt 1963 · S/N 28-10038 N8539NMcbride Ivan L · Toddville, IABuilt 1969 · S/N 28-11338 N8539WMccarthy Royal B · Eureka, CABuilt 1963 · S/N 28-10040 N853AAAb Prop Plane I LLC · Metairie, LABuilt 2026 · S/N 28010044 N853BTParadigm Aviation LLC · Sioux Falls, SDS/N 28R-7703076 N853NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881369 N853PUTrustees Of Purdue University · West Lafayette, INS/N 2881326 N853VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1966 · S/N 32-630 N8540FMckenney Charles W · Mount Ida, ARBuilt 1976 · S/N 32R-7780108 N8541NSunrise Aviation LLC · Sumrall, MSS/N 28-11340

Back to AD 87-08-08 R3