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.

N1969TN1969 Tango LLC · Green Cove Springs, FLBuilt 1971 · S/N 28-7105199 N196MTSheboygan Flying Club LLC · Sheboygan, WIBuilt 1964 · S/N 28-1880 N1973GBarrette Michael Patrick · Saginaw, MIBuilt 1973 · S/N 28-7305358 N197SATalley Rentals LLC · Hobart, OKFirst renewal noticeBuilt 1963 · S/N 28-1087 N1980TSpiegel Kirk · San Luis Obispo, CABuilt 1971 · S/N 28-7105200 N1981TWatson Barrett Consulting LLC · Hermitage, TNS/N 28-7105201 N1984TGettelfinger Bart A · Indianapolis, INBuilt 1971 · S/N 28-7105202 N1988TAtkins Robert M. · Hermosa Beach, CAFirst renewal noticeBuilt 1971 · S/N 28-7105203 N199Earth & Air LLC · Thompson Falls, MTBuilt 1964 · S/N 28-20568 N1990HTurner James Harvell · Montgomery, ALBuilt 1977 · S/N 28-7725175 N1992TReel Aviation Inc · Delray Beach, FLBuilt 1971 · S/N 28-7105217 N1995TMahmoud Khatib · Fayetteville, GABuilt 1971 · S/N 28-7105219 N199TPBlue Line Aviation LLC · Dunbar, NEBuilt 1972 · S/N 28-7325193 N199WBReinert Joseph Mason DBA · Chattanooga, TNBuilt 1963 · S/N 28-1040 N19GJJmd Aviation LLC · Guilford, CTBuilt 1973 · S/N 28-7405020 N19VTBeauchamp James W · Corapeake, NCBuilt 1962 · S/N 28-400 N1LPRegistration Pending · Lynn Haven, FLRegistration pendingBuilt 1965 · S/N 28-2666 N1MPFly One Mp LLC · Omaha, NEBuilt 1972 · S/N 28-7305143 N200MDArvelu LLC · Utica, NYBuilt 1973 · S/N 28-7305431 N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409 N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630 N2021RYergers Garage LLC · Leesport, PABuilt 1969 · S/N 28-5429 N2023RWhitehurst Brian P Trustee · Crossville, TNBuilt 1969 · S/N 28-5430 N2024RStorm David A · Lowell, ARBuilt 1969 · S/N 28-5432 N2028RMurphy Kevin Adam · Douglas, GABuilt 1969 · S/N 28-5437 N202ASQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 287305465 N202CBBrothers Aviation Va LLC · Manassas, VABuilt 1973 · S/N 28-7305360 N202MAHatchett William Hal · Edisto Island, SCBuilt 1970 · S/N 28-26740 N2034RPn4 Aviation Holdings LLC · Bishop, CABuilt 1969 · S/N 28-5439 N203MABuckau Michael S · Costa Mesa, CABuilt 1970 · S/N 28-26738 N203MDSinsaja Holdings LLC · Sheridan, WYBuilt 1976 · S/N 28-7625251 N2041RBlair Darrell E · Trinity, NCBuilt 1969 · S/N 28-5440 N2043RBoltjes Thomas S · Platte, SDBuilt 1969 · S/N 28-5441 N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443 N2049RHook Sean · Garden Ridge, TXBuilt 1969 · S/N 28-5445 N2052RDybvig Abraham M · Bothell, WABuilt 1969 · S/N 28-5444 N2062RMiller Mark T · Sugarcreek, OHBuilt 1969 · S/N 28-5447 N206CBLewis Jeffrey R · Parker, COBuilt 1974 · S/N 28-7425230 N2071RHughes Audie D · Starkville, MSS/N 28-5452 N2075RBuchart Cole Scott · Columbus, OHBuilt 1969 · S/N 28-5454 N2079RBrian K Vittorini · Bridgeton, NJBuilt 1969 · S/N 28-5455 N2086RRobison Robert S · Collinsville, ILBuilt 1969 · S/N 28-5458 N208EFAero208 LLC · Boise, IDBuilt 1966 · S/N 28-3632 N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975 N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459 N209SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7625115 N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393 N20PGSteiner Gregory L · Fort Lauderdale, FLBuilt 1966 · S/N 28-22276 N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461 N2109Klassen Wendell L · Mountain Lake, MNS/N 28-7425216

Back to AD 96-10-01 R1