Skip to content

Registered aircraft · 1,889

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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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.

N74080Lowry John O · Willis, TXBuilt 1975 · S/N AA5B-0121 N74086Meyer Michael · San Diego, CAFirst renewal noticeBuilt 1976 · S/N AA5B0394 N74088Mcgee Neil R · Littleton, NCBuilt 1975 · S/N AA5B-0125 N74090Tiger Air LLC · Chatsworth, CABuilt 1975 · S/N AA5B-0126 N74092Mcgill John G · Atlanta, GABuilt 1975 · S/N AA5B-0127 N74094Eastern Shore Flying Service Inc · Wilmington, DEBuilt 1976 · S/N AA5B0395 N74095Benson Edwin R · Gulfport, FLBuilt 1975 · S/N AA5B-0133 N74096Borden Lester N · Dalzell, ILBuilt 1975 · S/N AA5B-0134 N74099Sigg David · Bluffton, SCBuilt 1975 · S/N AA5B-0135 N74100Derby Kent E · Denver, COBuilt 1975 · S/N AA5B-0136 N74101Mickelsen Brian C · South Jordan, UTBuilt 1975 · S/N AA5B-0137 N74104Supan J T Trustee · Santa Cruz, CABuilt 1975 · S/N AA5B-0139 N74105Lamphier Marc S · Lawrence, MABuilt 1975 · S/N AA5B-0140 N74109Piscitello Thomas J · Yulee, FLBuilt 1975 · S/N AA5B-0145 N74127Richards Michael W · Lafayette, INBuilt 1975 · S/N AA5B-0147 N74141Spragg Zachary · Great Mills, MDBuilt 1975 · S/N AA5B-0155 N74143Fearn Richard · Gainesville, GABuilt 1975 · S/N AA5B-0158 N74146Vick Brian · Lutz, FLBuilt 1975 · S/N AA5B-0159 N74147Shoppell Stuart J · Dahlgren, VABuilt 1975 · S/N AA5B-0160 N74151Chapman Larry · Abilene, TXBuilt 1975 · S/N AA5B-0163 N74218Grumman Tiger LLC · Moorpark, CABuilt 1975 · S/N AA5B-0164 N74219Cmcs Aviation LLC · Atlantic Beach, FLBuilt 1975 · S/N AA5B-0165 N74225Campbell Thomas J III · Good Hope, GABuilt 1975 · S/N AA5B-0166 N74237Carino Jane Liu · Buckley, WABuilt 1975 · S/N AA5B-0169 N74243Marion Tiger LLC · Marion, INBuilt 1975 · S/N AA5B-0172 N74261Cunningham Glenn C · Manvel, TXBuilt 1975 · S/N AA5B-0176 N74262Mckay William J · Maitland, FLBuilt 1975 · S/N AA5B-0177 N74270R & D Bennett LLC · San Jose, CABuilt 1975 · S/N AA5B-0178 N74275Dail Alan Scot · Virginia Beach, VABuilt 1975 · S/N AA5B-0181 N74276Steinke Matthew R · Gibson, IABuilt 1975 · S/N AA5B-0184 N74292Patel Kalpesh · Chevy Chase, MDBuilt 1975 · S/N AA5B-0187 N74298Ariel Aircraft Corp · Wilmington, DEBuilt 1975 · S/N AA5B-0189 N74302Airpower Enterprises Ltd · Tampa, FLBuilt 1975 · S/N AA5B-0190 N74319Koch Christopher G · Coloma, MIBuilt 1975 · S/N AA5B-0199 N74323Clark Daniel M · San Pedro, CAS/N AA5B-0201 N74349Prieve Barton G · Aurora, COBuilt 1975 · S/N AA5B-0203 N74350Truong Philippe M · Fayetteville, ARBuilt 1975 · S/N AA5B-0204 N74356Windsor Robert M · Norman, OKBuilt 1975 · S/N AA5B-0206 N74359Ohlsson Patricia · Port Orange, FLBuilt 1975 · S/N AA5B-0207 N74374Speedbird Ventures LLC · Driftwood, TXBuilt 1975 · S/N AA5B-0209 N74399Sale Reported · San Dimas, CASale reportedS/N AA5B-0212 N74400Spira Greg · Chester, NJBuilt 1976 · S/N AA5B-0213 N74406Laplant Micheal J · Lago Vista, TXBuilt 1975 · S/N AA5B-0214 N74410Beran Jonathan R · Marshall, TXBuilt 1976 · S/N AA5B-0215 N74416Otto Joel C · Lander, WYBuilt 1976 · S/N AA5B-0217 N74417Wright Edward J · Louisa, VABuilt 1975 · S/N AA5B-0218 N74418Stamp David · Northville, MIBuilt 1976 · S/N AA5B-0221 N74429Xinther LLC · Belle Mead, NJBuilt 1975 · S/N AA5B-0223 N74434Lyet J Paul · Lititz, PABuilt 1975 · S/N AA5B-0224 N74438Pearl Jonathan D · Ocean City, MDBuilt 1975 · S/N AA5B-0226

Back to AD 95-19-15 R1