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.

N52322Flat Top Energy LLC · Ghent, WVBuilt 1973 · S/N 18262527 N52324Hailey Jeremy A · Burlington, WABuilt 1973 · S/N 18262528 N52328Ethridge Ed · Bigfork, MTBuilt 1973 · S/N 18262530 N52329Heber James A · Gansevoort, NYBuilt 1973 · S/N 18262531 N5232NFlorida Gas Transmission Co · Spring, TXBuilt 1980 · S/N 18267588 N5232UScruggs Kenneth R · Galloway, OHBuilt 1964 · S/N 206-0232 N52330Morgan John E · Waverly, TNS/N 18262532 N52332Beta Fleet LLC · South Burlington, VTBuilt 1973 · S/N 18262534 N52334Cooper Edwin H Jr · Austin, TXBuilt 1973 · S/N 18262536 N52337Willson Collin R · Lake Saint Louis, MOBuilt 1973 · S/N 18262538 N5233UKenai Gravel Products LLC · Salt Lake City, UTFirst renewal noticeBuilt 1964 · S/N 206-0233 N52342Child Todd A · Salt Lake City, UTBuilt 1974 · S/N 18262542 N52349Center O Flying Club · Tumwater, WABuilt 1973 · S/N 18262545 N5235DP2i Real Estate Ltd · Shreveport, LABuilt 1958 · S/N 50133 N52366Stewart Motor Co LLC · Wichita, KSBuilt 1973 · S/N 18262554 N52368Cook Jacy L · Bozeman, MTBuilt 1973 · S/N 18262556 N5236DSpiro Paul M · Anchorage, AKBuilt 1958 · S/N 50134 N52372Ratliff Huey C Jr · Homer, LABuilt 1973 · S/N 18262559 N52373Marine Resources Inc · Gilbert, AZBuilt 1973 · S/N 18262560 N52375Cattles Kenneth M · Lampasas, TXBuilt 1973 · S/N 18262561 N52376Stanley J James · Williamson, GABuilt 1973 · S/N 18262562 N52379International Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N 18262563 N5237ENvision Technology LLC · Turtle Lake, WIBuilt 1959 · S/N 50537 N52381Ifr Inc · Richmond, VABuilt 1973 · S/N 18262565 N52383Sugar Beach Investments LLC · Lillian, ALBuilt 1973 · S/N 18262566 N52389Levine Jeffrey L · Crescent City, FLBuilt 1973 · S/N 18262572 N5238DLewis Mechanical Inc · Wasilla, AKBuilt 1957 · S/N 50136 N52393Riverside County Sheriffs Department · Hemet, CABuilt 1973 · S/N 18262573 N52398Salzman Michael · Milford, NHBuilt 1973 · S/N 18262577 N5239DBatista Caleb · Beckley, WVBuilt 1957 · S/N 50137 N5239SHunnicutt Donald C · Meridianville, ALBuilt 1980 · S/N R18201521 N5239YDumitrache Christina Marie · Mankato, MNBuilt 2009 · S/N 18282169 N523DTKuwinda Air LLC · Midland, TXBuilt 1979 · S/N 18267130 N523DWFlagstaff Airlines LLC · Flagstaff, AZS/N 18261639 N523GGAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N 18267537 N523RCS W Air Travel Inc · Parshall, COBuilt 1975 · S/N 21060654 N523SMFirst Owl Creek LLC · Aspen, COS/N 18280747 N52400Bluestem Acquisitions LLC · Fort Worth, TXBuilt 1973 · S/N 18262578 N52402Sunny Aviation LLC · Kalispell, MTBuilt 1973 · S/N 18262580 N52405Dorward Alan C · Shreveport, LABuilt 1973 · S/N 18262583 N52406Prestige Aeronautics LLC · Haslett, MIFirst renewal noticeBuilt 1973 · S/N 18262584 N52409Cosner Dirk · Greeley, COBuilt 1973 · S/N 18262587 N5240DBailey Carlton D Jr · Huntington, WVBuilt 1957 · S/N 50138 N52415Pryor Stanley C · Indianapolis, INBuilt 1973 · S/N 18262591 N52416Toepfer Stan L · Lanark, ILS/N 18262592 N52420Isaacs John S · Fruitland Park, FLBuilt 1973 · S/N 18262596 N52422Stevens Michael C · Kaysville, UTBuilt 1973 · S/N 18262597 N5242EWeeks Charles C · Setauket, NYBuilt 1959 · S/N 50542 N52430Beaudikofer Eric · El Centro, CABuilt 1973 · S/N 18262602 N52431Lippian James Michael · New Boston, TXBuilt 1973 · S/N 18262603

Back to AD 84-10-01 R1