Skip to content

Registered aircraft · 20,481

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.

N9559XSkid Kids Aircraft Holding LLC · Grand Junction, COBuilt 1986 · S/N 18268555 N955BCWilson Douglas S · Imperial, NES/N 18263036 N955MSSanz Mark L · Missoula, MTBuilt 1974 · S/N 18262965 N95602King Douglas W · Bend, ORBuilt 1978 · S/N 18266575 N9560BAltair Aircraft LLC · Gainesville, FLBuilt 1957 · S/N 32857 N9560TStern Harvey W · Middletown, NYS/N 57360 N9560XSammons Richard Allen · Glen Arm, MDBuilt 1986 · S/N 18268556 N9561XAirxn LLC · Williams, AZBuilt 1962 · S/N 21057861 N9562THiggs Jared E · New Boston, TXBuilt 1960 · S/N 57362 N9562XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057862 N95631Tree Top Partners LLC · Berea, KYBuilt 1978 · S/N 18266585 N9563GLitzen Guide Service · Kenai, AKBuilt 1972 · S/N U20601763 N9563XGraham Raymond S · Citra, FLBuilt 1962 · S/N 21057863 N95649Hawker Aviation LLC · Lewes, DEBuilt 1978 · S/N 18266590 N9564TAlvarado Ruben Jr · Brownsville, TXS/N 57364 N95650Jnl Leasing LLC · Basalt, COS/N 18266591 N95659Uccellino Inc · Roslyn Heights, NYBuilt 1978 · S/N 18266593 N9565MBitterroot Ventures LLC · Show Low, AZBuilt 1998 · S/N 18280274 N9565XBerkbiegler Allen L · Lonedell, MOBuilt 1962 · S/N 21057865 N95661Godfrey Turhan L · Lewis Center, OHBuilt 1978 · S/N 18266594 N95677Steils Building Renovation And Management Inc · Lino Lakes, MNBuilt 1978 · S/N 18266596 N95678Jpr Aviation LLC · Hillsdale, INBuilt 1978 · S/N 18266597 N95682Longview Research And Development Inc · Chetek, WIBuilt 1978 · S/N 18266600 N95686Shutt Terence M · Goleta, CABuilt 1978 · S/N 18266602 N9568JJeep Kenneth M · Wadsworth, ILBuilt 1998 · S/N 18280275 N95696Cobb Brent D · Eden Prairie, MNBuilt 1978 · S/N 18266603 N9569TThomas Richard E · Lafayette, TNBuilt 1960 · S/N 57369 N9569XStepair LLC · Spring Valley, OHBuilt 1962 · S/N 21057869 N956BFMpd2 Inc · Valdosta, GABuilt 1971 · S/N 18260597 N956CFHighwind Aero LLC · Inyokern, CABuilt 2002 · S/N 18281075 N956CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282409 N956ESHr Cabinets LLC · Nederland, TXBuilt 2017 · S/N 18283013 N956SMMississippi Forestry Commission · Pearl, MSBuilt 2000 · S/N 18280783 N956WBEd Payne Motors Inc · Weslaco, TXBuilt 1981 · S/N 21064532 N9570AUpper Fifteen Inc · Latham, NYBuilt 1998 · S/N 18280286 N9570BStriplin Bradley H · Pittsboro, NCS/N 32867 N9570VAwp Holdings LLC · Murphysboro, ILS/N 18280285 N9570XGroves Chandler H DBA · Farmington, CAS/N 21057870 N9571BFarrell Mark A · Omaha, NEBuilt 1957 · S/N 32868 N9571XBarnett David Kirk · Brock, TXS/N 21057871 N95720Stilley John · Flagstaff, AZBuilt 1978 · S/N 18266608 N95721Copeland Danny K · Roseville, CABuilt 1978 · S/N 18266609 N9572AEagle Eye Marketing LLC · Reno, NVBuilt 1998 · S/N 18280279 N9572GJones Robert D Jr · Chugiak, AKBuilt 1972 · S/N U20601772 N9572XSparks James D · Glennallen, AKBuilt 1962 · S/N 21057872 N9573TLearn To Fly LLC · Portal, GABuilt 1959 · S/N 57373 N9573XLenyk Michael · Venice, FLBuilt 1986 · S/N 18268558 N9573ZBangert Richard E III · Seattle, WABuilt 1981 · S/N U20606549 N95740Nicholes Steven A Trustee · Portland, ORBuilt 1978 · S/N 18266615 N95747Eichelberger John Andrew · Winchester, MABuilt 1978 · S/N 18266617

Back to AD 84-10-01 R1