Skip to content

Registered aircraft · 318

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-18-05-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-18-05-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-18-05-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-18-05-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-18-05-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-18-05-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.

N242FWCoastal Air Service Inc · Panama City, FLBuilt 1991 · S/N 51506 N248AEAir Evac Ems Inc · O Fallon, MOBuilt 1985 · S/N 51129 N249THTimberland Helicopters Inc · Ashland, ORBuilt 1980 · S/N 45459 N24AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45646 N24WSCorvus LLC · Clovis, NMBuilt 1991 · S/N 51545 N255GTL3 Helicopter Inc · Miami, FLS/N 51217 N258AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45578 N25BH25bh LLC · Lewes, DEBuilt 1979 · S/N 45336 N25GHJbi South Leasing LLC · Pembroke, NHBuilt 1982 · S/N 45755 N2611Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45417 N2619Bank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 51375 N269AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51530 N2717WSf Leasing LLC · Norfolk, NEBuilt 1990 · S/N 51340 N271AEAir Evac Ems Inc · Ofallon, MOBuilt 1990 · S/N 51351 N274AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45762 N275AEAir Evac Ems Inc · O Fallon, MOBuilt 1986 · S/N 51186 N27694Orlando Aircraft Sales LLC · Orlando, FLS/N 45282 N277AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51421 N277TBSierra Flite LLC · Camden, DES/N 51189 N279THT & T Capital Inc · Bangor, MEBuilt 1986 · S/N 51176 N27AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45192 N27TKAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1985 · S/N 51138 N281AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51451 N282AEOas2 LLC · Orlando, FLBuilt 1991 · S/N 51452 N283BHJohnson Flying Service LLC · Exira, IABuilt 1991 · S/N 51510 N283RLMarks Lloyd · Lafayette, LAS/N 45283 N285AEAir Evac Ems Inc · O Fallon, MOBuilt 1992 · S/N 51550 N285RRBentley Drive LLC · Anchorage, AKBuilt 1982 · S/N 51041 N288AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51327 N28NAPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51387 N290AEAir Evac Ems Inc · O Fallon, MOBuilt 1986 · S/N 51192 N291SEzell Holdings LLC · Tucson, AZS/N 45698 N292AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45780 N293AEAir Evac Ems Inc · O Fallon, MOBuilt 1992 · S/N 51476 N295AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51455 N296AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45398 N296CCClayton County Police Department · Jonesboro, GABuilt 1990 · S/N 51389 N299AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45621 N29AEAir Evac Ems Inc · O Fallon, MOBuilt 1986 · S/N 51191 N2NJNew Jersey State Police · Ewing, NJBuilt 1985 · S/N 51-122 N303AENorth Wind Aviation LLC · Cottage Grove, ORBuilt 1979 · S/N 45348 N304CHPerfect Agreements Leasing · Trabuco Canyon, CAS/N 45388 N304MHBank Of Utah Trustee · Salt Lake City, UTBuilt 1983 · S/N 51047 N305CHGeco Inc · Wilmington, DES/N 45469 N306MHOlympic Jet Inc · Olympia, WABuilt 1991 · S/N 51449 N306PHFinish Line Aviation LLC · Pembroke, NHS/N 45411 N31079Top Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51526 N3107WWeyerhaeuser Nr Co · Seattle, WABuilt 1991 · S/N 51512 N311AEAir Evac Ems Inc · O Fallon, MOS/N 45572 N312NLYellowstone Wr Ranch LLC · Dillon, MTBuilt 1990 · S/N 51409

Back to AD 96-18-05 R1