Skip to content

Registered aircraft · 8,138

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.

N140AMSuchko Paul S · Venetia, PAS/N 28-26418 N140BCN504fl LLC · Killeen, TXBuilt 1971 · S/N 28-7125313 N140BKFrauenhoffer Kenneth E · Woodruff, WIBuilt 1975 · S/N 28-7525314 N140CKRegistered aircraftBuilt 1969 · S/N 28-26210 N140DDBe Right Back Aviation LLC · Billings, MTBuilt 1971 · S/N 28-7125145 N140FLYocum Stuart J · Kingman, AZBuilt 1971 · S/N 28-7125111 N140GBReel Christen · Leighton, ALBuilt 1967 · S/N 28 23806 N140HACarros Dale A · Cape Charles, VABuilt 1968 · S/N 28-25354 N140HCMurphy David B · Germantown, MDBuilt 1969 · S/N 28-25436 N140JFMeriden Aviation Center LLC · Meriden, CTBuilt 1973 · S/N 28-7325416 N140JNMfd Aviation Inc · Middletown, DEBuilt 1973 · S/N 28-7325244 N140KW47 North Aviation LLC DBA · Wenatchee, WAS/N 28-7625121 N140LRutten Paul J · Pine Island, MNBuilt 1967 · S/N 28-23057 N140MDDesotel Mark · Fairfax, IABuilt 1973 · S/N 28-7425149 N140NCRamirez Jesus Nicolas · Miami, FLBuilt 1975 · S/N 28-7525137 N140PLBennett Daniel C · Atlantic Beach, FLBuilt 1973 · S/N 28-7325663 N140SBSkyfusion II LLC · Atlanta, GABuilt 1969 · S/N 28-25681 N140SDG5 Services LLC · Myrtle Beach, SCS/N 28-22963 N140SHThomas Raymond · Daytona Beach, FLBuilt 1967 · S/N 28-22668 N140SNRomey Shelley · Newnan, GABuilt 1965 · S/N 28-21153 N140WMBlue Wings LLC · Rossville, TNBuilt 1972 · S/N 28-7305052 N140ZGitomirski Michael L · Moseley, VABuilt 1965 · S/N 28-20617 N1416TRegistered aircraftS/N 28-7225507 N1417TWood Andrew Calvin · Tallahassee, FLBuilt 1972 · S/N 28-7225508 N1418TZucchi Steven · Ephrata, PABuilt 1972 · S/N 28-7205295 N141KRScanlon John (Jack) · Palos Heights, ILBuilt 1972 · S/N 28-7225206 N141SWCouture Logan · Grand Forks, NDBuilt 1975 · S/N 28-7625006 N1422XDt'S Aviation LLC · Garden City, KSBuilt 1975 · S/N 28-7525287 N1423TWaggoner Kevin M · Donnellson, IABuilt 1972 · S/N 28-7225509 N1424TFoster Adam J · Houston, TXBuilt 1972 · S/N 28-7225511 N1428JLeedham James E DBA · Mazeppa, MNBuilt 1966 · S/N 28-3539 N142ASGray William Colin · Seattle, WABuilt 1966 · S/N 28-22530 N1432TSmith David · Belleville, ILBuilt 1972 · S/N 28-7205296 N1437TBenazzi Wahiba · Frisco, TXS/N 28-7225514 N1439XDovy Aviation LLC · Houston, TXBuilt 1975 · S/N 28-7525301 N143BSMoses Charles · West Friendship, MDBuilt 1966 · S/N 28-3792 N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348 N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358 N1442TKeller Mark · Alexandria, KYBuilt 1972 · S/N 28-7205298 N1446XN15956 Inc · Wilmington, DEBuilt 1975 · S/N 28-7525317 N1447HMarkovich David E · Eden Prairie, MNBuilt 1977 · S/N 28-7725144 N1447XGaventa Edward J · Logan Twp, NJBuilt 1975 · S/N 28-7525318 N1448XMallett Robert T · Wilmington, MABuilt 1975 · S/N 28-7505229 N144MC450 Dancer LLC · Benton Harbor, MIBuilt 1967 · S/N 28-22804 N1450TBruce James E · Prattville, ALBuilt 1972 · S/N 28-7205300 N1454XPetrak Richard A · Hunker, PABuilt 1975 · S/N 28-7505230 N1460XSimpson Arthur Lee · Richland Center, WIBuilt 1975 · S/N 28-7525293 N1461TNiepert William · Jacksonville, NCBuilt 1972 · S/N 28-7225522 N1462TWilliams Lesley J · Marquette, MIBuilt 1972 · S/N 28-7225523 N1462XVerbsky Douglas Collins · Frisco, TXBuilt 1975 · S/N 28-7525300

Back to AD 96-10-01 R1