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.

N4873FFirebrand Nation · Knoxville, TNS/N 28-7725034 N4873LBaker Justin · Titusville, FLBuilt 1967 · S/N 28-4229 N4875FVan Kirk Ronald · Wichita Falls, TXBuilt 1976 · S/N 28-7725033 N4877LTxp Designs LLC · Jasper, INS/N 28-4243 N4878LPeg Aviation LLC · Cedar Hill, TNBuilt 1967 · S/N 28-4244 N4878TLorbiecki John E · Hubertus, WIS/N 28-7205214 N4879TCombs Kenneth E · Canyon, TXBuilt 1972 · S/N 28-7225228 N487FLCarr Richard L · Cameron, WIBuilt 1971 · S/N 28-7125297 N487PLoehrer Michael A · Saint Cloud, MNBuilt 1965 · S/N 28-21080 N4880LHigginbotham Rome A · Zanesville, OHBuilt 1967 · S/N 28-4246 N4880TItechtives Company LLC · Purcellville, VABuilt 1972 · S/N 28-7225229 N4881LHoneycutt Stephen D · Ukiah, CABuilt 1967 · S/N 28-4247 N4881TFuller Aire Inc · Wilmington, DEBuilt 1972 · S/N 28-7205215 N4882LArapahoe Flight Club LLC · Colorado Springs, COBuilt 1967 · S/N 28-4248 N4883LMeixel Aviation LLC · Starbuck, MNBuilt 1967 · S/N 28-4249 N4885LMaximize Solutions Inc · Swan Lake, NYBuilt 1967 · S/N 28-4251 N4886LNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1967 · S/N 28-4252 N4887TRoe John C · Bonners Ferry, IDS/N 28-7225230 N4888TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225231 N4889LWerner Joseph H · Wauconda, ILBuilt 1967 · S/N 28-4255 N4889TS&P Aviation LLC · Albuquerque, NMS/N 28-7205217 N488PLutz Brian W · Russellville, ARBuilt 1965 · S/N 28-21081 N4891LToga LLC · Dayton, VABuilt 1967 · S/N 28-4258 N4891TRoss Stephen C · Santa Fe, NMBuilt 1972 · S/N 28-7205219 N4894LPeairs Gregory Ross · Sacramento, CABuilt 1967 · S/N 28-4261 N4896LMike Delta Kilo LLC · Bentonville, ARBuilt 1967 · S/N 28-4263 N4896TVosler Dean S · Bay City, MIBuilt 1972 · S/N 28-7225233 N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266 N4899TAra Airplanes LLC · Richmond, VAS/N 28-7205221 N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083 N4902LObrien William M · Aptos, CABuilt 1967 · S/N 28-4269 N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270 N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271 N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274 N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222 N4910LPeake Alexander · Tacoma, WABuilt 1967 · S/N 28-4275 N4911FFreed Michael L · Sylmar, CABuilt 1976 · S/N 28-7725035 N4911LMccown Brian W · Janesville, CABuilt 1967 · S/N 28-4276 N4913LHaven Mark · Springfield, TNBuilt 1967 · S/N 28-4278 N4914LWallace Aviation Inc · Wallace, NEBuilt 1967 · S/N 28-4279 N4915LRoss Robert J · Landisville, PABuilt 1967 · S/N 28-4280 N4916LMl Monkeybar Inc · Mammoth Lakes, CABuilt 1967 · S/N 28-4281 N4916TArithansa LLC · Big Bear City, CABuilt 1972 · S/N 28-7225281 N4917LBlankenbaker Myron K · Jacksonville Beach, FLBuilt 1967 · S/N 28-4282 N4918LAthene Solutions LLC · Coral Springs, FLBuilt 1967 · S/N 28-4283 N4919LCroft Jeffrey W · Tennessee Colony, TXBuilt 1967 · S/N 28-4284 N491DKey City Fliers · Maquoketa, IABuilt 1973 · S/N 28-7325632 N491ETKennebeck Ronald C · Johnston, IABuilt 1968 · S/N 28-24880 N491FLWashington Fliers Inc · Pantego, NCBuilt 1971 · S/N 28-7125304 N491GShelton Christopher O · Aubrey, TXBuilt 1968 · S/N 28-25022

Back to AD 96-10-01 R1