Skip to content

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N4838LSandstrom David E · Anchorage, AKBuilt 1967 · S/N 28-4182 N4838SDairy Air LLC · Lake Jackson, TXBuilt 1970 · S/N 32-1267 N4838TSnow Leopard Ltd · Incline Village, NVBuilt 1981 · S/N R18201774 N4838YWagner Nathan D · Dane, WIBuilt 1968 · S/N 25-4634 N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386 N4839LStandard David W · Toccoa, GABuilt 1967 · S/N 28-4183 N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012 N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99 N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688 N483FLOliver Zachary J · Seligman, AZBuilt 1971 · S/N 28-7125291 N483RVCoverstone Timothy L · Bellemont, AZBuilt 2004 · S/N 70175 N483SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 1998 · S/N 172S8029 N4840LIrons Eric P · Enoch, UTBuilt 1967 · S/N 28-4186 N4840TRegistered aircraftS/N R18201775 N4840YDmc Aircraft LLC · Naples, FLBuilt 1968 · S/N 25-4637 N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371 N4841FVidhun Raghuraman R · Southbury, CTBuilt 1976 · S/N 28-7790067 N4841LPapa India Echo Inc · Chambersburg, PABuilt 1967 · S/N 28-4187 N4841SPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1969 · S/N 32-1270 N4841YBlack Forest Soaring Society · Monument, COS/N 25-4639 N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995 N4842THampsten Jacob Clay · Mesquite, NVS/N 28-7225222 N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996 N4843PSherrill L H · Tucson, AZBuilt 1961 · S/N 27-414 N4843THuizenga Jamie L · Pierre, SDBuilt 1972 · S/N 28-7205205 N4843WMcclean Matthew James · Springfield, MOBuilt 1976 · S/N 14173 N48443Christian James B · Peyton, COBuilt 1943 · S/N 122 N4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeBuilt 1979 · S/N 17273088 N4844JSkoglun Eric W · Cashmere, WABuilt 1979 · S/N 17273684 N4844LHoover Liston LLC · Riverton, UTBuilt 1967 · S/N 28-4190 N4844TKings Wings LLC · East Wenatchee, WABuilt 1972 · S/N 28-7205206 N4845AParenteau William · Maple Grove, MNBuilt 1910 · S/N 22-3998 N4845FMattern Jeffrey A · Brunswick, OHBuilt 1976 · S/N 32R-7680482 N4845GNation Linda S · Sanford, FLBuilt 1979 · S/N 17273392 N4845JL&J Aviation Inc · Atwater, CABuilt 1979 · S/N 17273685 N4845SSt Cloud Flying Group LLC · Richmond, MNBuilt 1971 · S/N 28-7125381 N4846GNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1979 · S/N 17273393 N4846JMiehle Arthur R · Villa Park, ILBuilt 1968 · S/N 28R-30610 N4846LCoggins Beau · Alpine, TXBuilt 1967 · S/N 28-4379 N4846TChurchill Scott W · Le Sueur, MNBuilt 1972 · S/N 28R-7235125 N4846WPrice David · Loudon, TNS/N 14176 N4847GFlying Daze · Batavia, OHBuilt 1979 · S/N 17273394 N4847LKulwicki Gary Andrew · Seffner, FLBuilt 1967 · S/N 28-4192 N4847TKempton Larry G Jr · Grand Junction, COBuilt 1972 · S/N 34-7250158 N4847WIskin Jeffrey Trustee · Concord, CABuilt 1976 · S/N 14177 N4849AVeblen Raak · Auburn, CABuilt 1956 · S/N 22-4002 N4849DN4849d LLC · North Logan, UTBuilt 1979 · S/N 17272372 N4849LHummingbird Aviation LLC · Columbus, INBuilt 1967 · S/N 28-4198 N4849SCzyszczon Aviation LLC · St Pete Beach, FLBuilt 1970 · S/N 32-1289 N484ACReist David A · Mount Joy, PABuilt 1999 · S/N 425-99

Back to AD 87-10-06 R1