Skip to content

Registered aircraft · 2,553

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

N8047QAir Boys Inc · Hayward, WIBuilt 1970 · S/N 421B0047 N8050MPrice Earl · Audubon, PABuilt 1964 · S/N 310I0050 N8055MHuffman Jacob M III · Burleson, TXBuilt 1964 · S/N 310I0055 N8056MHooper David M Trustee · South Jordan, UTBuilt 1964 · S/N 310I0056 N8060MBata Michael R · Port Orange, FLS/N 310I0060 N8068QCreative Consulting Partners LLC · Fargo, NDBuilt 1974 · S/N 414-0503 N8071MLand Sea And Air Inc · North Mankato, MNS/N 310I0071 N8072MHigh Speed Flight Associates · Nickerson, KSS/N 310I0072 N8073MRussell David L · Wasilla, AKS/N 310I0073 N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300 N8081MHawk Hangars Corporation LLC · Jenks, OKS/N 310I0081 N8083MUpshaw John L Jr · Claude, TXBuilt 1964 · S/N 310I0083 N8085QWes Hughes Corp · Waldron, KSBuilt 1974 · S/N 414-0506 N8086MCaudell Michael A · Cleveland, GABuilt 1964 · S/N 310I0086 N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369 N8093QRobey Sean C · Camden, NCBuilt 1973 · S/N 421B0544 N8097MNovember Sierra Aviation LLC · Oneill, NES/N 310I0097 N80DWSale Reported · Lumberton, NCSale reported, pending cancellationBuilt 1958 · S/N 35782 N80FADma One LLC · Dayton, OHBuilt 1977 · S/N 310R0985 N80KRegistration Pending · Sparks, NVRegistration pendingBuilt 1963 · S/N 310H0098 N80PVRamos Investments Lp · Montgomery, TXBuilt 1977 · S/N 414-0963 N80RSRoberson Mark E · Milton, FLBuilt 1975 · S/N 421B0895 N8103MCunningham Michael J · Great Falls, MTBuilt 1964 · S/N 310I0103 N8109MRegistered aircraftBuilt 1964 · S/N 310I0109 N810SLidman Kirby · Ames, IABuilt 1964 · S/N 320B0062 N8112MFiedler Allen J · Imperial, PABuilt 1964 · S/N 310I0112 N8113MLansing Community College · Mason, MIBuilt 1964 · S/N 310I0113 N8116MJacobs Levon Jr · Oak Hill, FLBuilt 1964 · S/N 310I0116 N8118MRider Scott M · Beaverton, ORBuilt 1964 · S/N 310I0118 N811MCSatterthwaite Ryan W · Lynn Haven, FLS/N 35272 N811NAsplundh Eric P · Bryn Athyn, PAFirst renewal noticeBuilt 1978 · S/N 310R1317 N8122MNo Slack Flyers LLC · Klamath Falls, ORFirst renewal noticeBuilt 1964 · S/N 310I0122 N8125FMaglaughlin Ronald D · Udall, KSFirst renewal noticeS/N 402-0231 N8129QJolly Tyler S · Grover, COS/N 414-0029 N812VLa Plane LLC · Fort Thomas, AZBuilt 1972 · S/N 340-0157 N8131QClub Jet Investments LLC · Wilmington, DES/N 414-0031 N8133QFinnan-Johnson Flying Club LLC · Woodinville, WABuilt 1972 · S/N 310Q0626 N8134QPaul Morrill Excavating Inc · Newcastle, CABuilt 1969 · S/N 414-0034 N8136ZUniversity Of Alaska Anchorage · Anchorage, AKS/N 31010004 N8139MAcme Racing LLC · Overland Park, KSBuilt 1964 · S/N 310I0139 N8141MTerry Jan Chester · Beverly Hills, FLBuilt 1964 · S/N 310I0141 N8144QOcf Air LLC · Phoenix, AZBuilt 1970 · S/N 414-0044 N8145QWestern Nebraska Community College · Scottsbluff, NES/N 414-0045 N8147MDe La Rosa Sergio · Nogales, AZBuilt 1964 · S/N 310I0147 N814SWWenman Bradford Harris · Johnson, KSS/N 340-0197 N8150QSouthern Journey LLC · South Padre Island, TXS/N 414-0050 N8151QMiller James A Md · Merino, COS/N 414-0051 N8155ASkylane Ventures LLC · Keizer, ORS/N 310R0025 N815ACHakes Thomas A · Suring, WIBuilt 1975 · S/N 310R0597 N8166MMagafly LLC · Bay City, MIS/N 310I0166

Back to AD 76-08-02 R2