Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N55599Manning Holdings LLC · Portland, ORBuilt 1973 · S/N 28R-7335256 N5559PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-623 N555BECrocker William D · Toledo, WABuilt 1973 · S/N 28R-7335254 N555KLShemenski Aaron J · Tiverton, RIBuilt 1974 · S/N 28R-7535044 N555LFrankland Robert · Jackson, TNS/N 34-7970489 N555NSN8241r LLC · Leawood, KSBuilt 1969 · S/N 30-1790 N555TCArchibeque Christopher James · Albuquerque, NMBuilt 1977 · S/N 28R-7703061 N55610Luxury Aviation LLC · Butler, PABuilt 1973 · S/N 28R-7335258 N5561VPm Aviation Services LLC · Kailua, HIBuilt 1977 · S/N 34-7770253 N55628Ag Air Squadron Two LLC · Saint Joseph, ILBuilt 1973 · S/N 28R-7335261 N5563PVahey James T III · Loxahatchee, FLBuilt 1958 · S/N 24-627 N55641Gizzy LLC · Fish Creek, WIBuilt 1973 · S/N 28R-7335263 N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266 N55660Cifuentes Julio · Naples, FLS/N 28R-7335268 N5566PTwig And Giggleberries LLC · Wichita Falls, TXBuilt 1958 · S/N 24-630 N55677Arrow II Aviation LLC · Rocky Mount, NCBuilt 1973 · S/N 28R-7335270 N55678Murdick Robert A II · Bluemont, VABuilt 1973 · S/N 28R-7335271 N5567PRegistered aircraftS/N 24-631 N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632 N55695Straight Arrow Aviation LLC · Aurora, ILBuilt 1973 · S/N 28R-7335273 N55696Walla Walla University · College Place, WABuilt 1973 · S/N 28R-7335274 N55699Hill Caleb · Indianapolis, INBuilt 1973 · S/N 28R-7335281 N5569PSpirit Wings Ltd · Wilmington, DEBuilt 1958 · S/N 24-633 N55700Curry Edwin A · Pearland, TXBuilt 1973 · S/N 28R-7335279 N55711To Ivan K · Auburndale, FLS/N 28R-7335276 N5571PDaube Timothy B · Hampton, VAS/N 24-635 N55726Diedeman Thomas A · Lake City, FLBuilt 1973 · S/N 28R-7335278 N55756Piper Aircraft Inc · Vero Beach, FLBuilt 1973 · S/N 28R-7335267 N55763Walker William L · Norfolk, MABuilt 1973 · S/N 28R-7335283 N5576JIndiana Wings Inc · Indianapolis, INBuilt 1976 · S/N 32R-7680447 N5576PMark Stephens Farm Inc · Dutton, MTBuilt 1958 · S/N 24-640 N5577PHall Edmond · Bremerton, WAS/N 24641 N55786Calkins Mark · Nikiski, AKBuilt 1973 · S/N 28R-7335288 N5579PBucciarelli Dominick F · Pueblo, COBuilt 1958 · S/N 24-643 N55804Angert Phillip · Linden, NJBuilt 1973 · S/N 28R-7335291 N5580PJustice Nell E · Palmdale, CABuilt 1959 · S/N 24-644 N55821Dildy Douglas C · Albuquerque, NMBuilt 1973 · S/N 28R-7335295 N5582PPierce Stephen C · O Fallon, MOBuilt 1958 · S/N 24-646 N55830Rudd Clark David · Sheboygan Falls, WIBuilt 1973 · S/N 28R-7335296 N55837Mcqueen Bill · Turlock, CAS/N 28R-7335298 N5584PPinnell Roger D · Shell Knob, MOBuilt 1959 · S/N 24-648 N55855Caspersen Lars · Bloomsburg, PAS/N 28R-7335301 N5585PBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 24-649 N5586DOh Joseph K · Anaheim, CABuilt 1967 · S/N 28R-30116 N55877N A Corp · Scappoose, ORS/N 34-7350255 N55885Massa Paul G · Windsor Locks, CTBuilt 1973 · S/N 28R-7335305 N5588PNorth Town Comanche LLC · North Las Vegas, NVBuilt 1959 · S/N 24-654 N5589PEggers Cindy S · Winnemucca, NVBuilt 1959 · S/N 24-655 N558CMWells Airways LLC · Austin, TXBuilt 1978 · S/N 34-7870290 N558PCSammons Aero Services LLC · Edgewood, TXBuilt 1958 · S/N 24-333

Back to AD 97-01-01 R1