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.

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000 N1003CRogers Justin T · Kalispell, MTS/N 28-22741 N1004XRegistration Pending · Yucaipa, CARegistration pendingBuilt 1975 · S/N 28-7525256 N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194 N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509 N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489 N100WWSwearengin David · Lula, GABuilt 1967 · S/N 28-23611 N101JDresden Leasing LLC · Sheridan, WYBuilt 1965 · S/N 28-20898 N101MSKoenig William J · Benedict, MDS/N 28-7125519 N101NL1st American Aviation Inc · North Miami, FLBuilt 1967 · S/N 28-23419 N101RMWarren Isaac J · Tucson, AZBuilt 1965 · S/N 28-21184 N1020DLink Raymond III · Powell, OHBuilt 1974 · S/N 28-7425251 N1025XCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1975 · S/N 28-7525261 N1026HNeedham John A · Southington, CTBuilt 1973 · S/N 28-7325489 N1027BMarshall Loraine · Cincinnati, OHBuilt 1977 · S/N 28-7725246 N102FBWelch Richard J · Niceville, FLBuilt 1969 · S/N 28-26508 N102LCMy Technology Services LLC · Miami, FLBuilt 1967 · S/N 28-22860 N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198 N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552 N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265 N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092 N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199 N1046XFarnham Aviation Services LLC · Ames, IABuilt 1975 · S/N 28-7525266 N1051XNormand Glendon · Marksville, LABuilt 1975 · S/N 28-7525268 N1057XWeisenberger Thomas · Norwalk, OHBuilt 1975 · S/N 28-7505202 N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104 N1067QHard Rock Inc · Purcell, OKBuilt 1977 · S/N 28-7725179 N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204 N106MSKundel Richard · Cedar Rapids, IABuilt 1974 · S/N 28-7525063 N1071XPeter Prince Aviation Center LLC · Milton, FLBuilt 1975 · S/N 28-7525274 N1072QCoastal Air Inc · Groton, CTBuilt 1977 · S/N 28-7725180 N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206 N1079HJaremus Kent M · Olathe, KSS/N 28-7725131 N1079YBoyer Jerry D · Monument, ORBuilt 1962 · S/N 28-118 N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677 N1080XRegistration Pending · Houston, TXRegistration pendingS/N 28-7525278 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N1092TH4s Aviation LLC · Longview, TXS/N 28-25565 N1096TEvans Charles B · Benbrook, TXS/N 28-26284 N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287 N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612 N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482 N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210 N1104HSkydance Aviation LLC · Chesapeake, VAS/N 28-7725132 N1109XBruno Michael J · Pittsburg, CABuilt 1975 · S/N 28-7505211 N110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054 N1118ZMoorhouse Mark A · Santa Fe, TNBuilt 1963 · S/N 28-1118 N111FRAirward Inc · Novato, CABuilt 1972 · S/N 28-7325055 N111NPBlackfoot Aviation LLC · Bozeman, MTS/N 28-3046 N1122ACox Abraham · Key West, FLBuilt 1968 · S/N 28-25081

Back to AD 96-10-01 R1