Skip to content

Registered aircraft · 17,027

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

N22594Morton Eric C · Anchorage, AKBuilt 1968 · S/N 15068388 N22595Johnson Leif M · Midlothian, TXFirst renewal noticeBuilt 1968 · S/N 15068389 N22596Anderson Bradley P · Rapid City, SDBuilt 1968 · S/N 15068390 N22597Mcmanus Charles D · Cottageville, SCBuilt 1968 · S/N 15068391 N2259RLarson Lianne N · Irvine, CABuilt 1968 · S/N T210-0409 N225KCJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15070197 N225TCameron Mark · Big Arm, MTBuilt 1969 · S/N 18259960 N22602Williamson Mark T · Crescent City, CAS/N 15068396 N22609Kysar Ian R · Battle Ground, WAS/N 15068401 N2260JSeda Oswaldo · Stockbridge, GABuilt 1966 · S/N 15065460 N2260YReich Bruce D · Red Oak, IABuilt 1967 · S/N 17700060 N22612Wild Hair Aviation LLC · Centerville, WABuilt 1968 · S/N 15068402 N22615Word Charles A · Pensacola, FLBuilt 1968 · S/N 15068405 N2261RPetik Jason P · Sidney, NEBuilt 1968 · S/N T210-0411 N2261YKemper Dennis R · Carmichael, CABuilt 1967 · S/N 17700061 N22628Lemko Dennis A · Fresno, CABuilt 1968 · S/N 15068412 N2262YRegistered aircraftBuilt 1967 · S/N 17700062 N2263JJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15065463 N2263YMejia Mauricio · South Gate, CABuilt 1967 · S/N 17700063 N22645Martinez Emilio · Fairburn, GABuilt 1968 · S/N 15068424 N22648Eagles Wings Flight Training · Clintonville, WVBuilt 1968 · S/N 15068425 N2264JRegistered aircraftAssigned, pending cancellationS/N 15065464 N22656Berry Frank C · Watkinsville, GAS/N 15068431 N2265RHodhson Shell S · Wyocena, WIBuilt 1969 · S/N T210-0415 N2265YHemann Dale F · Osage, IABuilt 1967 · S/N 17700065 N22662Rogers Gary A · Novi, MIBuilt 1968 · S/N 15068433 N22663Auger Allan Dean · Conifer, COBuilt 1968 · S/N 15068434 N22667Firkus Lloyd Jason · Plover, WIBuilt 1968 · S/N 15068437 N2266JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15065466 N22673Merry Robert J · Lynnwood, WAFirst renewal noticeBuilt 1968 · S/N 15068440 N22676Burgess Barton C · Leesburg, OHBuilt 1968 · S/N 15068442 N22677Barlow Rod · Kaysville, UTBuilt 1968 · S/N 15068443 N2267YCole Gary L · Richmond, TXBuilt 1967 · S/N 17700067 N22680Turpen Andrew B · San Andreas, CAS/N 15068444 N22682Bianchi Brandon J · Castroville, CABuilt 1968 · S/N 15068446 N2268JKing Larry W · Port St John, FLBuilt 1966 · S/N 15065468 N22692Registration Pending · Metairie, LARegistration pendingS/N 15068452 N226DMFewel Lance E · Lake Oswego, ORBuilt 1976 · S/N 177RG0929 N226JTTerrell Jeffrey L · Clear Lake Shores, TXBuilt 1969 · S/N 18259919 N226WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 0476 N22702Ryan Good Aviation LLC · Sioux Falls, SDBuilt 1968 · S/N 15068459 N22706Sego James G · Sequim, WABuilt 1968 · S/N 15068461 N22708Arispe Aviation LLC · Mckinney, TXBuilt 1968 · S/N 15068462 N22709Riggin Flight Service Inc · Madison, SDS/N 15068463 N2270JFeland Wade · Antler, NDBuilt 1966 · S/N 15065470 N22716Rice Dwight D · Loma Linda, CABuilt 1968 · S/N 15068469 N2271RLowe Vance E · Oakland Park, FLBuilt 1969 · S/N T210-0421 N22722Roshchepa Yuriy · West New York, NJS/N 15068475 N22728Bero Patrick J · Pewaukee, WIBuilt 1968 · S/N 15068477 N22729Gavriilidis Gavriil · Palm Harbor, FLFirst renewal noticeBuilt 1968 · S/N 15068478

Back to AD 72-03-03 R3