Skip to content

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N23231Jones Robert A · Smyrna, DEBuilt 1968 · S/N 15068811 N23232Ozment Dennis W · Palmyra, MOBuilt 1968 · S/N 15068812 N23237Berrong Jimmy L · Dahlonega, GABuilt 1968 · S/N 15068817 N23238Plane Simple Rentals LLC · Monroe, MIBuilt 1968 · S/N 15068818 N2323D53u Aviation LLC · Bigfork, MTBuilt 1952 · S/N 20475 N2323NLee Marc · Goodyear, AZBuilt 1947 · S/N 12563 N2323UBurch Daniel C · Oakdale, MNBuilt 1962 · S/N 17249923 N23240Langwell Mary K · Arroyo Grande, CABuilt 1939 · S/N 3006 N23245Pike John P · Oregon City, ORBuilt 1939 · S/N 3013 N23246Pripps Seth D · Appleton, WIBuilt 1968 · S/N 15068823 N23248Kainu William M · Santa Rosa, CABuilt 1968 · S/N 15068824 N2324EBrown Craig D · Stanton, MIFirst renewal noticeBuilt 1946 · S/N 7AC5901 N2324NDicicco Matthew Trustee · Los Gatos, CABuilt 1947 · S/N 12564 N23254Chaimson Audra Hoy · Oregon, WIBuilt 1976 · S/N 2 N23261Asher Howard J · Kansas, OKBuilt 1968 · S/N 15068833 N23267Scherbon Scott W Sr · Amesbury, MAS/N 3033 N2326DDepue Amanda N · Wasilla, AKBuilt 1952 · S/N 20478 N23270Simco Aviation LLC · Petal, MSBuilt 1968 · S/N 15068837 N23271Monnig Hans J · Westerville, OHBuilt 1968 · S/N 15068838 N23273Herrema Kendra L · White Cloud, MIBuilt 1968 · S/N 15068840 N23274Brogmus Rhyan P · Marana, AZBuilt 1968 · S/N 15068841 N23275West David J · Plymouth, CABuilt 1968 · S/N 15068842 N23276Spellacy Cynthia L · Seaside, CABuilt 1968 · S/N 15068843 N23277Kressin Rayh · Waunakee, WIBuilt 1968 · S/N 15068844 N2327HDelaware Aviation Museum Foundation · Georgetown, DEBuilt 1946 · S/N 2952 N2327NStapleton Kenneth E · Nocona, TXBuilt 1947 · S/N 12585 N2327USprague Jeremiah A · Halfway, ORS/N 17249927 N23284Providence Industrial Electronics Repair Inc · Pilot Mountain, NCBuilt 1968 · S/N 15068848 N23287Bocanegra Jorge S · Greenville, NCBuilt 1968 · S/N 15068851 N23289Jb West Aviation LLC · Dumas, ARBuilt 1937 · S/N 3044 N2328BAaron Richard · Sussex, NJBuilt 1948 · S/N 3628 N2328NBlythe Anne T · Paso Robles, CAS/N 12586 N23290Walker Jeffrey · Warwick, NYBuilt 1968 · S/N 15068852 N23295Cook Erik C · Redmond, ORBuilt 1968 · S/N 15068855 N23299King Keith L · Lexington Park, MDBuilt 1968 · S/N 15068858 N2329BCarpino Kevin · Gretna, NEBuilt 1948 · S/N 3629 N2329DSwint David A · Henderson, NVBuilt 1952 · S/N 20481 N232BTHnw Aviation LLC · Melbourne, ARBuilt 1965 · S/N 15061302 N232PAZodiac Jockeys LLC · Wilmington, DEBuilt 2008 · S/N 650-104 N233Stone Scott Robert · New Waverly, TXBuilt 1968 · S/N 15068882 N23302Adams John C · Gladstone, MOBuilt 1968 · S/N 15068860 N23303Chuzy Suzy LLC · Lafayette, LABuilt 1968 · S/N 15068861 N23304Gendy Shady S · Columbia, PABuilt 1968 · S/N 15068862 N23305Fuhrmann Brandon R · Aberdeen, SDBuilt 1968 · S/N 15068863 N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864 N2330BPeck John A Jr · Shady Shores, TXS/N 3630 N2330NWheadon William J · Napa, CABuilt 1947 · S/N 12570 N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866 N2331DJensen William C · Brookshire, TXBuilt 1952 · S/N 20483 N2331N642 Flyers LLC · Mankato, MNS/N 12571

Back to AD 94-05-05 R1