Skip to content

Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N55957Blumie Thomas C · Jewett City, CTBuilt 1973 · S/N 32-7340148 N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317 N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897 N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883 N5595PCassell Joseph · Singer, LABuilt 1959 · S/N 24-662 N5595QLivezey Patrick · Lithia, FLBuilt 1965 · S/N 2988 N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318 N55965Greene County Flying Club · Waynesburg, PABuilt 1973 · S/N 28-7305510 N55967Hisman Gary L · Skagway, AKS/N 28-7305511 N55968Tindle David W · Fennville, MIFirst renewal noticeS/N JC-1 N5596JJenny LLC · Hudsonville, MIBuilt 1968 · S/N 32-1037 N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326 N55970Soaring Eagle Aviation LLC · Carmi, ILBuilt 1973 · S/N 34-7350266 N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543 N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545 N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512 N55979Acumen Aerotech LLC · Rogers, TXBuilt 1973 · S/N 28R-7335321 N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853 N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327 N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733 N55986Turner Jeffrey K · Gastonia, NCBuilt 1973 · S/N 28R-7335322 N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549 N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064 N5598JMakfly LLC · Chardon, OHBuilt 1968 · S/N 32-1065 N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328 N5598WBall Dontel J · Tacoma, WAS/N 28-734 N55990Registered aircraftN-number assigned, not yet registeredS/N 28R-7335323 N55996Mcfarlane Randall C · Loudonville, NYBuilt 1973 · S/N 28R-7335325 N5599BMccain David O · Ashville, ALBuilt 1980 · S/N 0828 N5599KDayton Walter S · Napa, CAS/N R18200922 N5599QFerraro Christopher · Croydon, PABuilt 1965 · S/N 2990 N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736 N559BDBiggs Aviation LLC · Decatur, INBuilt 2004 · S/N 1470 N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299 N559ESeitan Eduard · Chicago, ILS/N 28-3248 N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400 N559JPNelson Scott E · Whispering Pines, NCBuilt 1978 · S/N 32R-7885276 N559JRHardie George G Jr · Lancaster, CABuilt 2004 · S/N T18208309 N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286 N559MANorwood Kenneth Trustee · Rogers, ARBuilt 2000 · S/N 3246159 N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170 N559PTracy Theodore W · West Chester, OHBuilt 2007 · S/N 317 N559PDCrocker Donald E · Eagle, IDBuilt 2015 · S/N 91817 N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096 N559RKRegistration Pending · Sheridan, WYRegistration pendingBuilt 1999 · S/N 0559 N559RVBrady Norman M · Port Orange, FLBuilt 2009 · S/N 90978 N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410 N559TJHangar 22 LLC · Watkinsville, GABuilt 2000 · S/N 18280852 N55ADSchrage Rodney L · Steamboat Springs, COBuilt 1977 · S/N 1006 N55AFRegistration Pending · Terre Haute, INRegistration pendingS/N 32-864

Back to AD 87-10-06 R1