Skip to content

Registered aircraft · 20,483

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:84-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:84-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:84-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:84-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:84-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:84-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.

N2812RBullin Keith · Bryan, TXBuilt 1967 · S/N 18258412 N2813FDan Air LLC · Greenville, SCBuilt 1966 · S/N 18256913 N2814KMacario Mark A · Weirsdale, FLBuilt 1979 · S/N 18053085 N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998 N2814RCypress Aviation Inc · Naples, FLBuilt 1967 · S/N 18258414 N2814YYankee Tango Mike LLC · Dublin, TXS/N 18253814 N2815KStudniski Alois W · Saint Joseph, MNS/N 18053086 N2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1967 · S/N 18258415 N2815YFlakes LLC · Fort Worth, TXBuilt 1962 · S/N 18253815 N2816KVigna Douglas Del · Portland, MEBuilt 1979 · S/N 18053087 N2817ARamey Shane · Buffalo, WYBuilt 1953 · S/N 30017 N2817C2817c Inc · Wilmington, DEBuilt 1978 · S/N R18200231 N2818FMccullough Andrew · Lubbock, TXS/N 18256918 N2818YEaton Melvin W II · Saint Onge, SDS/N 18253818 N281AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281189 N281DKN281dk LLC · Brandywine, MDBuilt 2005 · S/N 18281719 N281RWR Wings LLC · Deland, FLBuilt 2026 · S/N 18283340 N281SLCurly Aviation LLC · Atlanta, GABuilt 1972 · S/N 182-61394 N2820RHutter Karl G · Reno, NVBuilt 1967 · S/N 18258420 N2821ALewton John E · Belgrade, MTBuilt 1953 · S/N 30021 N2821K4608 Vista LLC · Fort Lauderdale, FLS/N 18053089 N2821RNielson David L Trustee · Anchorage, AKBuilt 1967 · S/N 18258421 N2822MWendt Robert R · Sedona, AZBuilt 1953 · S/N 30010 N2823AMckinney Eric S · Hamersville, OHS/N 30023 N2824AStrode Lawrence W · Naknek, AKS/N 30024 N2825FStephens Jeffrey G · Gig Harbor, WABuilt 1966 · S/N 18256925 N2825ROjeda Holdings LLC · Gainesville, GABuilt 1967 · S/N 18258425 N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025 N2825YSalva Kenneth J · Shingle Springs, CABuilt 1962 · S/N 18253825 N2826AConfer Gary R · Washougal, WABuilt 1953 · S/N 30026 N2827CCalifornia Equipment Leasing LLC · Marina Del Rey, CABuilt 1978 · S/N R18200233 N2828ALatham Cory D · Great Bend, KSS/N 30028 N2828FSmiley Neil J Trustee · Lake Havasu City, AZBuilt 1966 · S/N 18256928 N2828KStephens Mark Edwin Trustee · Morgan Hill, CABuilt 1979 · S/N 18053091 N2828YHooey Kevin M · Beaver Dams, NYBuilt 1962 · S/N 18253828 N2829YN2829y LLC · Longmont, COFirst renewal noticeBuilt 1962 · S/N 18253829 N282ABVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282139 N282CPWright Andrew T · Clyde, OHBuilt 1958 · S/N 51546 N282EL282el LLC · Pendleton, ORS/N 182-67682 N282ESC282es LLC · Tampa, FLBuilt 1996 · S/N 18280002 N282HDDavis Aviation LLC · Wilkesboro, NCBuilt 2005 · S/N 18281631 N282JPMarshalls Sanitation Services LLC DBA · Fallon, NVBuilt 1977 · S/N 18265923 N282MTMissig James M · Great River, NYBuilt 1997 · S/N 18280079 N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068 N282RFDevault Michael E · Fairmont, WVBuilt 1968 · S/N 18259466 N282TWLake Of The Woods Aviation LLC · Baudette, MNBuilt 1977 · S/N 18265943 N2830RCae Flying Club Of Ohio · Toledo, OHBuilt 1967 · S/N 18258430 N2831KBjorkman Glenn A · Goleta, CABuilt 1979 · S/N 18053092 N2832RMabe Bradley L · Cascade, IDBuilt 1967 · S/N 18258432 N2833AMamuzich Robert J DBA · Deming, NMS/N 30033

Back to AD 84-10-01 R1