Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N8339ZLetendre Brian Paul · Troy, MOBuilt 1981 · S/N 32-8124013 N8341HDbc Aviation LLC · Charlotte, NCBuilt 1981 · S/N 32R-8129047 N8341PLife Is Flying Inc · Deerfield Beach, FLBuilt 1963 · S/N 24-3596 N8342FSmith John S · Canal Winchester, OHBuilt 1982 · S/N 32R-8329006 N8343BGc Aviation Services LLC · Springboro, OHS/N 32-8124014 N8343URiley Air LLC · Phoenixville, PAS/N 32R-8329008 N8348PEchols Mark R · Diana, TXBuilt 1964 · S/N 24-3605 N834NQAlaska Door LLC · Wasilla, AKBuilt 1977 · S/N 31-7752070 N8355HLjmf 17 LLC · Hays, KSBuilt 2001 · S/N 3257204 N8355XSkyway Leasing Co Inc · Yakima, WABuilt 1981 · S/N 32R-8129053 N8359MColeman Russell L · Port Charlotte, FLBuilt 1981 · S/N 32-8124019 N8359SSoda Aviation LLC · Lexington, KYBuilt 1981 · S/N 32-8124020 N8360GSophamike Aviation LLC · Hattiesburg, MSBuilt 1981 · S/N 32R-8129057 N83615Brown Thomas E · Union Grove, ALBuilt 1981 · S/N 32R-8129058 N8366PBurris Robert V · Charlotte, NCBuilt 1964 · S/N 24-3624 N8367CBuckwalter Daniel E · Homer, AKBuilt 1976 · S/N 32-7640061 N8368COchoa Luis M · Hollywood, FLBuilt 1976 · S/N 32R-7680102 N8375CHammett Jeb Stuart · Monroe, LABuilt 1976 · S/N 32R-7680103 N83808Jcl Aviation Inc · Palm Harbor, FLBuilt 1981 · S/N 32R-8129065 N8381VAurora Direct LLC · West Linn, ORBuilt 1981 · S/N 32-8124025 N8383PWhatley Mark · Orion, MIBuilt 1964 · S/N 24-3642 N8384CMountain Flying Adventures LLC · Missoula, MTBuilt 1976 · S/N 32R-7680105 N8384LMaring Inc · Blaine, MNBuilt 1981 · S/N 32R-8129054 N8386HSierra Aero · Carson City, NVBuilt 1981 · S/N 32R-8129067 N83894Sale Reported · Grangeville, IDSale reportedBuilt 1981 · S/N 32-8124029 N8392PVaughn Charles P · Inverness, FLBuilt 1964 · S/N 24-3652 N8393XAeroforge LLC · Crystal Lake, ILBuilt 1981 · S/N 32R-8129074 N8396JCurtsinger Joseph C Jr · Nolensville, TNBuilt 1981 · S/N 32R-8129075 N839SAUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608391 N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171 N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307 N83JFForker John S · Orcas, WABuilt 1995 · S/N LIV 192 N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050 N83RAPessoa Guiherme · Winter Garden, FLS/N 31-638 N83WCRegistered aircraftBuilt 1966 · S/N 27-3281 N84008Harkey Wesley · Sherrills Ford, NCBuilt 1981 · S/N 28R-8131145 N8401DDarwin D Pluid · Eureka, MTBuilt 1981 · S/N 32R-8129076 N8403DTelford Aircraft LLC · Telford, TNS/N 32R-8129078 N8403PNewell Douglas Bryon · Sedalia, MOBuilt 1964 · S/N 24-3659 N8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationBuilt 1964 · S/N 24-3660 N8405PCarlin Chad P · San Juan Capistron, CAS/N 24-3661 N8408PBeavers Jeffrey · Metairie, LABuilt 1964 · S/N 24-3664 N8409HAerocolibri LLC · Nampa, IDBuilt 1981 · S/N 32R-8129084 N8409YRivera William Carl · Silver Spring, MDBuilt 1981 · S/N 32R-8129086 N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669 N841ADCedar Real Estate Inc · Anaheim, CABuilt 1973 · S/N 32-7340079 N841ATLuxury Transportation LLC · Talladega, ALBuilt 2004 · S/N 3257352 N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684 N841WBQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 32R-7887075 N84219Manhattan Management Corp · Brooklyn, NYS/N 88

Back to AD 81-12-06 R1