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.

N5580WSmitty 172 LLC · Rockford, MIS/N 28-691 N55811Scott Tyler C · Ball Ground, GABuilt 1973 · S/N 28-7325490 N55816Flying Manatees LLC · Wilmington, DEBuilt 1973 · S/N 28-7325492 N55818Lovejoy Aviation LLC · Cato, NYBuilt 1973 · S/N 28-7325494 N55819Younger Christopher · Corona, CABuilt 1965 · S/N 28-10609 N5581JKts Spar Bay LLC · Coral Gables, FLBuilt 1968 · S/N 32-1038 N5581WRay Justin P · Centre, ALBuilt 1962 · S/N 28-666 N55821Dildy Douglas C · Albuquerque, NMBuilt 1973 · S/N 28R-7335295 N55823Steele Lawrence D · Belleair Beach, FLBuilt 1973 · S/N 28-7305436 N55824Ray Foster Stephen · Stockton, CABuilt 1973 · S/N 28-7325495 N55827Debonis Nicholas Michael · Woodland, CABuilt 1973 · S/N 287305477 N5582UPatterson Saralyn · Oklahoma City, OKS/N 28-26311 N5582WRieger Karen M · Indianapolis, INBuilt 1962 · S/N 28-697 N55830Rudd Clark David · Sheboygan Falls, WIBuilt 1973 · S/N 28R-7335296 N55837Mcqueen Bill · Turlock, CAS/N 28R-7335298 N55838Hintenlang David · Archer, FLBuilt 1973 · S/N 28-7305435 N55839David Gill · Marietta, GAS/N 28-7310133 N5583FAiken Pilot Training LLC · Johnston, SCBuilt 1968 · S/N 28-24916 N5583J5150 Ventures LLC · Effingham, ILBuilt 1968 · S/N 32-1043 N55840Walko Michael E · Scotch Plains, NJBuilt 1973 · S/N 28-7325551 N55842Ansboro James C · Goshen, NYBuilt 1973 · S/N 28-7325502 N55844Cozby Charles L · Wellsboro, PAS/N 28-7325503 N5584FGuiliano Anthony · Tobyhanna, PABuilt 1968 · S/N 28-24917 N5584JDelano James B · Laverne, CABuilt 1968 · S/N 32-1044 N5584WDill Mark B · Amarillo, TXBuilt 1962 · S/N 28-658 N55852Ingold Terry L · Albemarle, NCBuilt 1973 · S/N 28-7305484 N55855Caspersen Lars · Bloomsburg, PAS/N 28R-7335301 N55856Alpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1973 · S/N 32-7340143 N5585FSouth Texas Air Force LLC · Mission, TXBuilt 1968 · S/N 28-24918 N5585JPhb Aviation Inc · Melbourne Beach, FLBuilt 1968 · S/N 32-1027 N5586DOh Joseph K · Anaheim, CABuilt 1967 · S/N 28R-30116 N5586USoisson Douglas M · Barnesville, GABuilt 1969 · S/N 28-26316 N5586VFisher Robert W · Katy, TXS/N 28-7716183 N55870Legacy Aviation LLC · Tea, SDS/N 28-7305487 N55879Buchholtz Tony E · Greenville, OHBuilt 1973 · S/N 28-7325485 N5587VNorth Country Aviation LLC · Kalispell, MTS/N 28-7716184 N55880Wings Up LLC · Saint Augustine, FLBuilt 1973 · S/N 28-7325517 N55881Phoenix Kingdom LLC · Washington, DCS/N 28-7325518 N55884Mcgee Daniel J · Indianola, IABuilt 1973 · S/N 28-7305491 N55885Massa Paul G · Windsor Locks, CTBuilt 1973 · S/N 28R-7335305 N5588FRckr Aviation LLC · Chehalis, WABuilt 1968 · S/N 28-24921 N5588UMontgomery Richard E · Omaha, NEBuilt 1969 · S/N 28-26318 N5588WBartz Nicole · Cleveland, MOBuilt 1962 · S/N 28-725 N55890S & L Sports LLC · New Hampton, IABuilt 1973 · S/N 28-7305492 N55899Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28-7325521 N5589FTjl Aviation LLC · Atlanta, GABuilt 1968 · S/N 28-24922 N5589UGq Aviation LLC · Cherry Hill, NJBuilt 1969 · S/N 28-26320 N5589VKempton Larry G Jr DBA · Grand Junction, COS/N 28-7716185 N558FLRoyal Greene Holdings LLC · Spout Spring, VABuilt 1971 · S/N 28-7125399 N558KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843879

Back to AD 87-08-08 R3