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.

N496HMTalon Air Service Inc · Soldotna, AKBuilt 1976 · S/N 17267496 N496LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020074 N496MAEzboost LLC · Torrance, CABuilt 2005 · S/N 40.496 N496MGRippy Gregg P · Glenwood Springs, COBuilt 1992 · S/N 1213 N496SPWingsleasing LLC · Wichita, KSBuilt 1998 · S/N 172S8037 N496TPVertical Corporation · Kalispell, MTBuilt 1991 · S/N 1646 N496WWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 2023 N4970LAzflyers LLC · Gilbert, AZBuilt 1967 · S/N 28-4344 N4970SMapoles Aviation · Pace, FLS/N 28R-35690 N4971FRegistration Pending · Cottonwood, CARegistration pendingBuilt 1979 · S/N 17273110 N4971GSuper Hawk Inc · West Jordan, UTBuilt 1979 · S/N 17273518 N4971JCreasy Frank Edward III · Suffolk, VABuilt 1968 · S/N 28R-30722 N4971LNathanson David · Los Angeles, CAS/N 28-4345 N4971PDodt Clinton Carl · Broomfield, COBuilt 1963 · S/N 27-573 N4971TRegistered aircraftBuilt 1972 · S/N 28-7225295 N4971VGorman John Scott · Homosassa, FLBuilt 1980 · S/N 172RG0436 N4972GMcchuck Properties LLC · Pensacola, FLBuilt 1979 · S/N 17273519 N4972LRush City Flyers · North Branch, MNBuilt 1967 · S/N 28-4346 N4972TPhilema Turf Inc · Americus, GABuilt 1981 · S/N R18201810 N4973FBoraam Aviation Inc · Prospect Heights, ILBuilt 1979 · S/N 17273111 N4973JTroftgruben Gregory G · Buxton, NDS/N 28R-30724 N4973LRahjes Luke D · Kensington, KSBuilt 1967 · S/N 28-4347 N4973PAviation Business Corp · Saint Louis, MOS/N 27-574 N4974GPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 17273521 N4974LPotratz Douglas R · Oshkosh, WIBuilt 1967 · S/N 28-4348 N4975FFg Aviation LLC · La Jolla, CABuilt 1979 · S/N 17273112 N4975GBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17273522 N4975JP&N Corp · Marion, IABuilt 1968 · S/N 28R-30727 N4975LMcnabb Brandy T · Milton, FLS/N 28-4349 N4975VMiller David M · Fort Worth, TXBuilt 1980 · S/N 172RG0440 N4976FLytle John A · Anaheim, CABuilt 1980 · S/N 172-73113 N4976GOklahoma Airmen Flying Club Inc · Jenks, OKS/N 17273523 N4976LLawrence Kenneth White · Chuckey, TNBuilt 1967 · S/N 28-4350 N4976SLogsdon David · Carmel, INBuilt 1970 · S/N 28R-35692 N4976VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 172RG0441 N4976WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 14296 N4977JJad Corp · Saint Cloud, MNBuilt 1968 · S/N 28R-30730 N4977LApple Tree Aviation LLC · Gibsonia, PABuilt 1967 · S/N 28-4352 N4977SMatheaus Michael · Sequin, TXBuilt 1970 · S/N 28R-35696 N4977YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4748 N4978GJin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273525 N4978TRoth Robert A · Pacific Palisades, CABuilt 1981 · S/N R18201811 N4978VGeorgeson Troy D · Sheyenne, NDBuilt 1980 · S/N 172RG0442 N4979ESmith Corey C · Campton, NHBuilt 1984 · S/N 782 N4979SDunn James J · San Ramon, CABuilt 1970 · S/N 28R-35698 N4979VRobertson Roy E · Marion, IABuilt 1980 · S/N 172RG0443 N497BWSwartz Taylor A · Fayetteville, NCBuilt 2014 · S/N 90762 N497DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816567 N497ERPlane Three Ltd · Wilmington, DEBuilt 1998 · S/N 17280673 N497FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125314

Back to AD 87-10-06 R1