Skip to content

Registered aircraft · 579

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:2002-21-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-21-13') 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:2002-21-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-21-13')
  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:2002-21-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-21-13')
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.

N80406Johnson Raymond · Eldridge, NDBuilt 1947 · S/N D-6 N80409Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-9 N80411Parkin Steven H · Yucca Valley, CAS/N D-11 N80412Nason David F · Kent, WABuilt 1947 · S/N D-12 N80418Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-18 N80423N80423 LLC · Palisade, COS/N D-23 N80429Cary William R · Graniteville, SCBuilt 1947 · S/N D29 N80431Biggs Aircraft Inc · Wellston, OKBuilt 1947 · S/N D-31 N80435Christopher T Hoke · Edmond, OKBuilt 1947 · S/N D-35 N80438Newhard Glenn K · Bethlehem, PABuilt 1947 · S/N D-38 N80444Furmanski Stan · Encino, CAFirst renewal noticeBuilt 1947 · S/N D-44 N80445Cromley Russell B · Odessa, FLBuilt 1947 · S/N D-45 N80465Right Coast Ventures LLC · Royse City, TXBuilt 1947 · S/N D-65 N809TSMedic Choppers LLC · Springdale, ARS/N D-809 N8403ACrittenden William R · Dunwoody, GABuilt 1948 · S/N D-1815 N8410ABonanza Parts · Davis, CAS/N D-1847 N8412AZeien Robert A · Charlton, MAS/N D-1849 N8425AKeshishian Gregory · New York, NYFirst renewal noticeBuilt 1948 · S/N D1862 N8430AMontgomery Patrick E · Auburn, NYBuilt 1948 · S/N D-1844 N8431ABas Part Sales LLC · Greeley, COBuilt 1948 · S/N D-1845 N8434AShepard Roger C · Aberdeen, WABuilt 1948 · S/N D-1850 N8440AWeller Donald R · Kathleen, GABuilt 1948 · S/N D-1846 N8452AHoward Jordan Stevens · Tioga, NDS/N D-1870 N8456ACrawford Larry G · California, MOS/N D-1874 N8461ALove Larry E · Greenbrier, ARBuilt 1949 · S/N D-2012 N8465AKeys James B · Oakwood, GABuilt 1948 · S/N D-1883 N8467ARegistration Pending · Tucson, AZRegistration pendingBuilt 1948 · S/N D-1885 N8478ABrice Staeheli · Saint Paul, MNS/N D-1898 N8482AEngelhart Mitchell S · Roswell, GABuilt 1948 · S/N D-1902 N8483AHeller Louis T · Reno, NVBuilt 1948 · S/N D-1903 N8490AUrquhart Dan DBA · Fallon, NVBuilt 1948 · S/N D-1910 N8497AHaynie Walter R · Brooklyn, IABuilt 1948 · S/N D-1919 N8501ARosanova Richard Shane · Flagstaff, AZBuilt 1948 · S/N D-1923 N8507ATidwell Jim O · Canton, GABuilt 1949 · S/N D1929 N8511ASipple Ronald W Jr · Gardner, KSBuilt 1949 · S/N D-1933 N8518ALapinel Marc P · Long Beach, NYS/N D-2018 N8519AMyers Travis · Bridgeport, WVBuilt 1949 · S/N D-2019 N8525AAuten Charles W III · Parker, COBuilt 1949 · S/N D-2023 N8531AChappie Michael R · Sidney, OHS/N D-1953 N8538AWeeks Stanley III · Taneyville, MOS/N D-1960 N8558AAerobanc Of America Inc · Camarillo, CABuilt 1949 · S/N D-1980 N8565AHendricks Allan T · Pearland, TXBuilt 1949 · S/N D-1987 N8571AWilliams Alan P · Bossier City, LABuilt 1949 · S/N D-1993 N8577ANissen Chris · Sandy, ORBuilt 1948 · S/N D-1999 N8578ABonanza Parts Inc · Davis, CABuilt 1949 · S/N D-2000 N8585AFervida Jeffrey B · Milford, INBuilt 1949 · S/N D-2007 N8588AAbbott R Barry · Tempe, AZBuilt 1949 · S/N D-2010 N8595ANorthshore Flyers · Houston, TXBuilt 1949 · S/N D-2033 N8602AHardcopf Robert W · Apple Valley, MNBuilt 1949 · S/N D-1989 N8605ADifferent Auto LLC · Twin Falls, IDBuilt 1948 · S/N D-1928

Back to AD 2002-21-13