Skip to content

Registered aircraft · 54,015

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N6112SHall Metal Corp · Fort Pierce, FLBuilt 1980 · S/N R18201615 N6112TSnell Matthew · Ackerly, TXBuilt 1964 · S/N 15060812 N61130Registration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 15070823 N61131Anderson Jerry · Vacaville, CABuilt 1969 · S/N 15070824 N61132Whithaus Douglas A · Panama City, FLBuilt 1969 · S/N 15070825 N6113EPlane Old LLC · Bristol, VTBuilt 1958 · S/N 46213 N6113FOrmsby Engineering & Aviation LLC · Georgetown, INBuilt 1975 · S/N 18264116 N6113GPratt Aviation Services Inc · Anchorage, AKBuilt 1969 · S/N 15071613 N6113RColorado Northwestern Community College · Rangely, COBuilt 1979 · S/N 172RG0086 N6113VLegacy Lsa LLC · Plainview, TXBuilt 1980 · S/N 172RG0581 N61140Johnson Darryl W · Fowler, COBuilt 1969 · S/N 15070831 N61141Holmes Meg C · Winterport, MEBuilt 1969 · S/N 15070832 N61143Hedlund Wesley H · Newburgh, MEBuilt 1969 · S/N 15070834 N61144Schenk Flight Service LLC · Ainsworth, NEFirst renewal noticeBuilt 1969 · S/N 15070835 N61145N61145 LLC · Seattle, WAS/N 15070836 N6114RJstream Lc · Sheridan, WYS/N T210-0014 N6114SGoral William W · Redlands, CABuilt 1980 · S/N R18201616 N61152Cunneen Regan M · Vista, CABuilt 1969 · S/N 15070841 N61155Smith Jacques F · Anchorage, AKS/N 18504114 N61156Williams Tommy J · San Angelo, TXBuilt 1969 · S/N 15070845 N61157Bravo Holdings LLC · St Francis, WIBuilt 1969 · S/N 15070846 N61158Robert N Shadduck Inc · Annandale, MNBuilt 1980 · S/N 18504115 N61159Stenger D James Trustee · Sonora, CABuilt 1969 · S/N 15070847 N6115NHartwick John H · Goodyear, AZS/N 18267789 N6115SGan Specialties Inc · Pocatello, IDBuilt 1980 · S/N R18201617 N6115TIngegno Frank N · Carmel, INS/N 15060815 N61163Miller William M · Enterprise, KSBuilt 1969 · S/N 15070851 N61164Brydon Robert J · Lago Vista, TXBuilt 1980 · S/N 18504117 N61166Om Air LLC · Saint Louis, MOS/N 15070852 N61168Sherwood Ronald R · Kathleen, GABuilt 1969 · S/N 15070854 N6116GWilbur David W · Marlow, NHBuilt 1969 · S/N 15071616 N6116RAirxn LLC · Williams, AZBuilt 1965 · S/N T210-0016 N6116YSaab35 Draken Inc · Pocono Pines, PAS/N 21064256 N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602 N61172Celeste Nash · Vista, CAS/N 15070858 N61176Closson Dennis L · Red Wing, MNBuilt 1969 · S/N 15070862 N61177Spenner John T · Fenton, MOBuilt 1969 · S/N 15070863 N61178Seman Kenneth H · Ravenna, OHBuilt 1969 · S/N 15070864 N6117EViveros Ezequiel · Calexico, CABuilt 1983 · S/N 18268346 N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017 N6117MFayette Hawks Flying Club Inc · Somerville, TNBuilt 1980 · S/N 15284625 N6117NTaylor Willis P III · Suffolk, VABuilt 1980 · S/N 18267790 N61182B2 W Corporation · Winona, MNBuilt 1969 · S/N 15070867 N61184Lawson Gary R · Olympia, WAS/N 15070869 N61186Petit Leon · Virgil, ILBuilt 1969 · S/N 15070871 N61187Registration Pending · Burleson, TXRegistration pendingBuilt 1969 · S/N 15070872 N61189Orr Jeffrey N · Waco, TXBuilt 1969 · S/N 15070874 N61190Freed Richard H · Watervliet, MIBuilt 1969 · S/N 15070875 N61192Possemato Domenic · Lincoln, NHS/N 15070877 N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502

Back to AD 87-20-03 R2