Skip to content

Registered aircraft · 1,406

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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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.

N57187Reddy Vivek V · Kelseyville, CABuilt 1983 · S/N 24-1432 N57252Mooney Flyers LLC · Crystal Lake, ILBuilt 1984 · S/N 24-1433 N57257Moulton Lawrence W · Westlake Village, CAS/N 24-1605 N57259Trantham Joey L · Panama City, FLBuilt 1984 · S/N 24-1435 N57267Devine Robert · Albuquerque, NMBuilt 1984 · S/N 24-1436 N5726MSolano Edwin G · Fort Atkinson, WIBuilt 1983 · S/N 24-1418 N57280Conklin Michael L · Grand Blanc, MIBuilt 1984 · S/N 24-1438 N57283Collins James L · Bradenton, FLBuilt 1984 · S/N 24-1439 N57336Wolfe Roark · Flagstaff, AZBuilt 1984 · S/N 24-1441 N5734JBewley Terry V · White Oak, TXBuilt 1984 · S/N 24-1442 N5735PPlanecrazyd LLC · Portal, GABuilt 1984 · S/N 24-1444 N57376Christian Medical Mission Aviation Support Inc · Waco, TXBuilt 1984 · S/N 24-1446 N5737NBingham Clifton Wade · West Lafayette, INBuilt 1984 · S/N 24-1445 N5739JIntegrative Aerospace Corp · Aliso Viejo, CABuilt 1984 · S/N 24-1448 N57413Miller Sybille A · Ashburn, VABuilt 1984 · S/N 24-1450 N5742ZBootz Terry A · Canyon Lake, TXBuilt 1984 · S/N 24-1451 N5744JLopresti Curtis · Vero Beach, FLBuilt 1984 · S/N 24-1443 N57492Trimble Tanner J · Blue Rapids, KSBuilt 1984 · S/N 24-1455 N5749MRegistration Pending · Apple Valley, CARegistration pending, canceledS/N 24-1609 N5749XFlash Aviation LLC · Elkton, MDBuilt 1984 · S/N 24-1454 N5750MStites Holdings LLC · Seattle, WAS/N 24-1457 N57540Trent Blaine · Fort Myers, FLBuilt 1984 · S/N 24-1459 N57552Sheets Gregory W · Ocala, FLBuilt 1984 · S/N 24-1460 N57557Hopping Jon · La Mesa, CABuilt 1984 · S/N 24-1461 N57559N57559 LLC · Elgin, ILBuilt 1984 · S/N 24-1462 N5756KMoquin Thomas A · Hampshire, ILBuilt 1984 · S/N 24-1463 N5759BTjelle Michael J · Coal City, ILBuilt 1984 · S/N 24-1465 N5760RChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1984 · S/N 24-1466 N5760TBradley Brent E · Arvada, COBuilt 1984 · S/N 24-1467 N5763LHylander Jared R · Elizabeth City, NCBuilt 1984 · S/N 24-1470 N5763XStatewide Transportation LLC · Oklahoma City, OKBuilt 1984 · S/N 24-1473 N5763YLane Phillip C · Peru, INBuilt 1984 · S/N 24-1474 N5764HSleepytime Pllc · Eagle, IDBuilt 1984 · S/N 24-1477 N5764JLevy Laurent · Quakertown, PABuilt 1984 · S/N 24-1478 N5764KDevine Robert L · Condon, ORBuilt 1984 · S/N 24-1479 N57651Maxeiner Kenneth · Lake Charles, LABuilt 1984 · S/N 24-1484 N57658Datum Air Inc · Saint Matthews, SCBuilt 1984 · S/N 24-1486 N57663Swim Charles W · Bozman, MDBuilt 1984 · S/N 24-1489 N5766XEagles Flyers Inc · Eldridge, IABuilt 1984 · S/N 24-1487 N5766YEbbers Stephen L · Bluffton, SCBuilt 1984 · S/N 24-1488 N5767KSoham Oaks LLC · Kalispell, MTBuilt 1984 · S/N 24-1491 N5767ZEtter Robert · Burlington, VTBuilt 1984 · S/N 24-1492 N5768BStratford Advancement LLC · Brooklyn Park, MNBuilt 1984 · S/N 24-1494 N5771FSchutz Garrett · Alamogordo, NMBuilt 1984 · S/N 24-1497 N5772MRutigliano Pasquale T · Aquebogue, NYBuilt 1984 · S/N 24-1501 N5772RFlying Particles Inc · Livermore, CABuilt 1984 · S/N 24-1502 N57737North Creek Aviation LLC · Kilgore, TXBuilt 1984 · S/N 24-1503 N5775MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 24-1505 N57766Smith Danny E III · Covington, INS/N 24-1506 N5777HNeff Thomas J · Novato, CABuilt 1984 · S/N 24-1507

Back to AD 95-26-16 R1