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.

N38248Plane Training LLC · Rapid City, SDBuilt 1977 · S/N 28-7716234 N3824TStevens Zane Kelly · Carthage, TNBuilt 1967 · S/N 28R-30141 N3824WTeel Brian P · Hooper, UTBuilt 1966 · S/N 32-756 N38250Elkins John H · Lancaster, MABuilt 1977 · S/N 28-7790531 N38254Syracuse Flying Club Inc · Fayetteville, NYBuilt 1977 · S/N 28-7790534 N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085 N3825TArmstrong Aviation Services LLC · Freeport, PABuilt 1967 · S/N 28R-30143 N3825WKaizen Companies Inc · Boise, IDBuilt 1966 · S/N 32-757 N38265Recipe System US Inc · Torrance, CABuilt 1977 · S/N 28-7716236 N38267Andy Mack Management LLC · Wilmington, DEBuilt 1977 · S/N 28-7716237 N3826WMiller Heather J · Dupo, ILBuilt 1966 · S/N 32-759 N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086 N38275Von Duyke Mark A · Des Moines, WABuilt 1977 · S/N 28R-7703198 N38276N38276 LLC · Las Vegas, NVBuilt 1977 · S/N 32-7740081 N3827MFox James Douglas · Pittsburg, ILBuilt 1978 · S/N 28-7890335 N3827TBrauer Noah J · Covington, KYBuilt 1967 · S/N 28R-30145 N38291Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716240 N38293L & A Bennett Second Family L P · Renton, WAS/N 28-7790537 N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087 N3829TFreese Pamela L · Frederic, WIBuilt 1967 · S/N 28R-30147 N382BTPiper Aircraft Inc · Vero Beach, FLS/N 28010086 N382DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843845 N382FSSmith Michael L · Smyrna, SCS/N 32-7700019 N382HP382 Hp LLC · Pt Pleasant Beach, NJBuilt 2006 · S/N 3257411 N382JMGullicksrud Mark Robbe · Strum, WIBuilt 1981 · S/N 32R8229026 N382NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881828 N38305Wulf Aerospace LLC · Santa Rosa Beach, FLBuilt 1977 · S/N 32R-7780413 N3830TStevenson Shane C · Sicklerville, NJBuilt 1967 · S/N 28R-30148 N3830WKris Noone Air LLC · Wilmington, DES/N 32-764 N38311Archair Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 28-7790538 N38312Barnes Carl A · Jacksonville, FLS/N 28-7725261 N38313Lwr LLC · Teton, IDBuilt 1977 · S/N 28-7725262 N38315Meyer Lynn O · Olathe, KSBuilt 1977 · S/N 28-7725275 N38316Meriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7716241 N38319Fronduto Cody Michael · Fort Pierce, FLBuilt 1977 · S/N 28-7790539 N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138 N3831QTahmass Ahmad · Mission Viejo, CAS/N 28-7911039 N38321Owens Richard Salad Inc · St Simons Is, GABuilt 1977 · S/N 28-7790541 N38324De Oliveira Antonio J · Fuquay Varina, NCBuilt 1977 · S/N 28-7790535 N3832TFrysinger Melvin D · Weatherford, TXBuilt 1967 · S/N 28R-30150 N38331Johnston Craig J · Ocean City, NJBuilt 1977 · S/N 32-7740082 N38334Gsm Air LLC · Old Tappan, NJBuilt 1977 · S/N 32R-7780415 N38338Rafter W Ranches LLC · Johnson, KSBuilt 1977 · S/N 32R-7780416 N3833WKurz Sean H · Blairsville, PABuilt 1966 · S/N 32-767 N3834RK J Aviation LLC · Jasper, INBuilt 1970 · S/N 28-5828 N3834TJsl Instructional Services LLC · Fort Worth, TXS/N 28R-30152 N38356John Prosock Machine Inc · Quakertown, PABuilt 1977 · S/N 28-7790543 N38357Carr Mark · Wshngtn Ct Hs, OHS/N 28-7790544 N3835THuber Charles H · Medina, OHBuilt 1967 · S/N 28R-30153 N38368Dubisar Milo Richard · Redmond, ORBuilt 1977 · S/N 32R-7780419

Back to AD 87-08-08 R3