Skip to content

Registered aircraft · 72,007

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.

N34444Lil Red Cardinal LLC · Phoenix, AZBuilt 1972 · S/N 17701807 N34445East Carolina Aviation LLC · Camden, NCBuilt 1972 · S/N 17701808 N34448Schleicher Conan A · Salem, ORBuilt 1972 · S/N 17701809 N3444NPeck Justin · Forest City, PABuilt 1967 · S/N 680055 N3444THunter David Frederick · Peachtree City, GABuilt 1968 · S/N 17700744 N3444XBrey Ronald P · Van, TXS/N 1132 N3444ZLewanski Richard B · Sheridan, ILS/N 22-7363 N34453Porcaro James · Latham, NYS/N 17701814 N3445EHicks Robert C · Atkins, VABuilt 1978 · S/N 17271551 N3445WTrembly Alexander · Horner, WVBuilt 1965 · S/N 32-311 N3446Benjamin Harold E · New York, NYBuilt 2012 · S/N 3446 N34464Morgan Michael B · Stanwood, WAFirst renewal noticeBuilt 1972 · S/N 17701821 N34465Brodbeck William J · Kyle, TXBuilt 1972 · S/N 17701822 N34467Drust Joseph L · Menominee, MIBuilt 1972 · S/N 17701824 N34469Kroll Richard L · Kalamazoo, MIBuilt 1972 · S/N 17701826 N3446TR & B Air LLC · Clayton, MOBuilt 1968 · S/N 17700746 N3446XLin-Aero LLC · Conway, ARBuilt 1966 · S/N 3407 N34471Grass Dennis Lee Trustee · Grass Valley, CABuilt 1972 · S/N 17701827 N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418 N3447TLocander Paul · Olney, MDBuilt 1968 · S/N 17700747 N3447WStimart Rene D Trustee · Harshaw, WIBuilt 1965 · S/N 32-314 N3447XRmm Enterprises Inc · Isabel, SDS/N 3408 N34484Fingerhut Victor R Jr · Ponce, PRFirst renewal noticeBuilt 1972 · S/N 17701833 N34489Plexis Management Inc · Cheyenne, WYFirst renewal noticeBuilt 1972 · S/N 17701837 N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419 N34490Peterson Frazer C Trustee · Payette, IDBuilt 1972 · S/N 17701838 N34491Hazelwood Dennis L · Mount Vernon, MOBuilt 1972 · S/N 17701839 N3449MCarhart Thomas M · Galesville, WIBuilt 1977 · S/N 28R-7837114 N3449THedrick Bill E · Kilgore, TXBuilt 1968 · S/N 17700749 N344ATTagir Abkadirov · Tampa, FLS/N 1354 N344BAWoodring Mark W · ProvidencialesNon-citizen corporation, flight hours not reportedS/N 0570908 N344BBMansfield Heliflight · Milton, VTBuilt 2001 · S/N 1159 N344CCDorsey Dale · Charlotte, NCBuilt 1995 · S/N 22084 N344CFKey West Helicopters LLC · Key West, FLBuilt 2004 · S/N 10440 N344CRPattern Altitude Aviation Standards LLC · Sandy, UTS/N 28-153 N344DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843832 N344ESLake Superior Helicopters LLC · Duluth, MNBuilt 2015 · S/N 2402 N344GStobbe Marlin · Ethridge, TNBuilt 2003 · S/N 10099 N344LCDuyk Charles W · Saint Petersburg, FLBuilt 2018 · S/N 2564 N344MARomeo Romeo LLC · Lewes, DEBuilt 2003 · S/N 40.344 N344RLRed R44 LLC · Wilmington, DEBuilt 2019 · S/N 2598 N344SAShier Aviation DBA · San Diego, CABuilt 2017 · S/N 30012 N344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267 N344TXCline Lyndi · Royce City, TXBuilt 1966 · S/N 24-4478 N344YUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30056 N34500Miller Judy Carole · No Palm Beach, FLBuilt 1972 · S/N 17701843 N34506Tibbs Gary R · Marietta, GABuilt 1972 · S/N 17701846 N3450WRst Aviation LLC · Vero Beach, FLBuilt 1965 · S/N 32-317 N3450XCarey Patrick M · Citrus Heights, CABuilt 1966 · S/N 1136 N34511Mazure Glenn J · Bad Axe, MIBuilt 1972 · S/N 17701849

Back to AD 87-10-06 R1