Skip to content

Registered aircraft · 8,139

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:96-10-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:96-10-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:96-10-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:96-10-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:96-10-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:96-10-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.

N5398WTrussell Robert Eugene Jr · Covington, TXS/N 28-466 N5399LWinters Charles B · Farmington, NMBuilt 1968 · S/N 28-4708 N539MFKovarik Kevin · Fort Atkinson, IABuilt 1972 · S/N 28-7305064 N5400WGuches Jim D · Caldwell, IDBuilt 1962 · S/N 28-468 N5401WWegner Eric E · Oconomowoc, WIBuilt 1962 · S/N 28-469 N5402FMorgan Kristopher Lm · Crowley, TXBuilt 1976 · S/N 28-7725054 N5402SCharlie Ten Inc · Quakertown, PABuilt 1971 · S/N 28-7105139 N5403FAcs Wings LLC · Deerfield Beach, FLBuilt 1976 · S/N 28-7725055 N5406WScott Jeffrey E · Connersville, INBuilt 1962 · S/N 28-475 N5407WThird Step 6 LLC · Gilbert, AZBuilt 1962 · S/N 28-476 N540FLGregory James A · East Burke, VTBuilt 1971 · S/N 28-7125372 N5415S98x LLC · Caddo Mills, TXBuilt 1970 · S/N 28-7125113 N5416SNelson Stephen A · Milaca, MNBuilt 1971 · S/N 28-7125114 N5417SHiga Bertram T · Northridge, CARegistration expired, pending cancellationBuilt 1971 · S/N 28-7125116 N5417WCrystal Lake Air LLC · Lake Geneva, FLS/N 28-488 N5419SAberdeen School District · Aberdeen, MSBuilt 1971 · S/N 28-7125117 N5420WGade Donald A · Antioch, ILS/N 28-491 N5421WBrown David A · Olympia, WAFirst renewal noticeBuilt 1962 · S/N 28-492 N5422SVanwagnen Brian J · Jackson, MIBuilt 1971 · S/N 28-7125118 N5424SNeely Benson W · Florence, MSBuilt 1971 · S/N 28-7125119 N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497 N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500 N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374 N5431WBig Daddys Casino Inc · Huntington, WVBuilt 1962 · S/N 28-506 N5432WVantilborg Craig S · Minot, NDBuilt 1962 · S/N 28-507 N5435WGabriel Juan J · Melbourne Beach, FLBuilt 1962 · S/N 28-510 N54364Parker Realty Co · Brunswick, GABuilt 1973 · S/N 28-7405047 N54369Don Warren D · Chandler, AZBuilt 1973 · S/N 28-7425110 N5437WRoutson David P · Dundee, MIBuilt 1962 · S/N 28-513 N5438WHoward Arthur L · Lake City, MNBuilt 1962 · S/N 28-514 N54390Mcclelland Kip · Douglas, GAS/N 28-7405049 N5439WRegistration Pending · Gary, SDRegistration pendingS/N 28-515 N543FLMorpac Aviation Inc · Wayne, NJBuilt 1971 · S/N 28-7125376 N54401Martin Duane C · Brownsburg, INS/N 28-7425120 N54405Noel Michael R · Tucson, AZBuilt 1973 · S/N 28-7405051 N54420Gibson Andrew P · Goleta, CABuilt 1973 · S/N 28-7425128 N5442WHarris Joshua J · Athens, TXBuilt 1962 · S/N 28-519 N54433Registered aircraftBuilt 1973 · S/N 28-7425130 N54435Bond Investigations Aviation LLC · Phoenix, AZS/N 28-7425132 N54445Jensen Allen R · Tremonton, UTBuilt 1973 · S/N 28-7425134 N54447Soares Sergio Cardoso · Hillside, NJBuilt 1973 · S/N 28-7405055 N5444FAnderson Aviation LLC · Bulverde, TXS/N 28-7725060 N54457Plane Sailing LLC · Lawrenceville, GAS/N 28-7425138 N5445WIsom Colin A · Shawano, WIBuilt 1962 · S/N 28-522 N54462Loon Aviation LLC · Northfield, MNBuilt 1973 · S/N 28-7405056 N54466Field George Walker DBA · Bedminster, NJBuilt 1973 · S/N 28-7425139 N54468Legacy Training Group · Oklahoma City, OKS/N 28-7425141 N5446WSmith June Ann M · Tucson, AZBuilt 1962 · S/N 28-523 N54471Jamerson Scott C · Charleston, WVBuilt 1973 · S/N 28-7405057 N54478Lavi Nir · Burlington, MAS/N 28-7425142

Back to AD 96-10-01 R1