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.

N22435Pearson Charles C · Covington, LABuilt 1968 · S/N 15068279 N22436Pecht Scott A · Reedsville, PABuilt 1968 · S/N 15068280 N22439Birginia Aviation LLC · Forest, VAS/N 15068283 N2243BSlys Aircraft Service · Platte, SDBuilt 1950 · S/N 6670 N22448Eddy Lisa M · Benton, KSBuilt 1968 · S/N 15068291 N2244HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 2867 N22452Waddy Bertha L · Villa Ridge, ILBuilt 1968 · S/N 15068292 N2245BTardiff Richard A Trustee · Kealakekua, HIBuilt 1949 · S/N 6672 N2245JRiver City Aviation LLC · Carmichael, CAS/N 15065445 N2245VGustav Flabelhauser LLC · Spokane, WABuilt 1948 · S/N 14519 N22462Organ Daniel W · Vernonia, ORBuilt 1968 · S/N 15068298 N2246BBendelius Robert J · Accord, NYBuilt 1949 · S/N 6673 N2246CKorman Nicholas · Lebanon, INBuilt 1946 · S/N 8098 N2246DBiagioni Paul M · Anchorage, AKBuilt 1952 · S/N 20398 N2246JMcmurray Jay C · Niota, TNBuilt 1966 · S/N 15065446 N2246PCade Chris J · Canton, TXBuilt 1994 · S/N 516 N22475Ace Aeromotive Inc · Miami, FLBuilt 1968 · S/N 15068306 N22477Ray Erin N · Manor, TXFirst renewal noticeBuilt 1968 · S/N 15068307 N2247HGerdes Brian K · Los Alamitos, CABuilt 1946 · S/N 2870 N2247JHeathers Houses Foundation Inc · Fort Lauderdale, FLBuilt 1966 · S/N 15065447 N22484Tinoco Joseph I · Shoreline, WABuilt 1968 · S/N 15068310 N22487Skyguard Instruction LLC · Ann Arbor, MIBuilt 1968 · S/N 15068312 N22488Oneal Sean M · Santa Cruz, CABuilt 1968 · S/N 15068313 N22489Sky Walker Flight School LLC · Adrian, MIBuilt 1968 · S/N 15068314 N2248NSmith David J · Duluth, MNS/N 12484 N22491Yasumiishi Joy Marie Trustee · Juneau, AKS/N 15068316 N22498Evans Thomas G · Dawson, ALS/N 15068318 N22499Johnson Dale B · Steele, NDBuilt 1968 · S/N 15068319 N224DCGarrison Carl O · Fresno, CABuilt 1979 · S/N 1353 N22501Smith Dylan Lane · Oklahoma City, OKBuilt 1968 · S/N 15068321 N2250DBruce Jason W · Stone Mountain, GABuilt 1952 · S/N 20402 N2250JLuce Frederick M · Brookshire, TXBuilt 1966 · S/N 15065450 N22513Sutton Bradley V · Dallas, TXBuilt 1939 · S/N 7083 N22515Wheeler Bret · La Grande, ORBuilt 1968 · S/N 15068329 N22523Beene Donald L · Westfield, INBuilt 1968 · S/N 15068334 N22526Staloff Jason A · Greenfield, MABuilt 1968 · S/N 15068337 N22528Hhd Aviation LLC · Hamilton, OHBuilt 1968 · S/N 15068339 N22529Rhodes Stephen D · Hendersonville, NCS/N 15068340 N2252VZampa Joseph A · Whitewater, COBuilt 1948 · S/N 14483 N22533Regner Mark W · Danbury, CTBuilt 1968 · S/N 15068343 N22536Reep Jennifer B · Stone Mountain, GABuilt 1968 · S/N 15068345 N22537Ernst Albert S III · Buda, TXS/N 15068346 N2253VBurnet Robert C · Niceville, FLBuilt 1948 · S/N 14484 N22540Mcgovern Thomas F · Blue Springs, MOBuilt 1968 · S/N 15068347 N22542Apgyn And Associates Inc · Coral Springs, FLBuilt 1968 · S/N 15068349 N22544N1705r Inc · Cobb, CAS/N 15068351 N22548V2 Aviation LLC · Mishawaka, INBuilt 1939 · S/N 7131 N2254FHudson Daryl J · Redwood Valley, CABuilt 1974 · S/N 15076160 N2254NPokorski Kenneth R · Bisbee, AZBuilt 1947 · S/N 12490 N2254VPhillip Ashiku · Ukiah, CAS/N 14485

Back to AD 94-05-05 R1