Skip to content

Registered aircraft · 579

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

N3858NDvorak Jerry Joseph · Ravenna, OHFirst renewal noticeBuilt 1947 · S/N D-1097 N3869NBenson George R · Woodlake, CABuilt 1947 · S/N D-1110 N387Mcghee Johnny A · Louisburg, NCBuilt 1947 · S/N D-916 N3874NV Tail LLC · Milford, CTBuilt 1947 · S/N D-1116 N3886NBetson Kevin C · Newport Coast, CABuilt 1947 · S/N D-1130 N390Buford Phillip N · Bethesda, DCBuilt 1947 · S/N D-901 N3920NAllen Sanford B · Everett, WABuilt 1947 · S/N D-1175 N3921NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-1177 N3932NKearby Derek L · Greenbrier, ARS/N D-1189 N3934NCan Do Aviation · Siloam Springs, ARBuilt 1962 · S/N D-1191 N3935NBravo Humberto H · Harker Heights, TXBuilt 1947 · S/N D-1192 N3941NCarlson Brent A · Shelley, IDBuilt 1948 · S/N D-1257 N3943NHunt John A · Marion, KYBuilt 1948 · S/N D-1290 N3954NNagy Richard C · Shepherd, TXBuilt 1947 · S/N D-1214 N3958NKash Ronald D · Mansfield, OHS/N D-1218 N3959NRobinson Shawn Tracy · Valencia, PABuilt 1947 · S/N D-1219 N3975NBas Part Sales LLC · Greeley, COS/N D-860 N3993NBeck Larry A · Arkdale, WIS/N D-2237 N3KWBeute Walter A · Palatka, FLBuilt 1947 · S/N D-828 N406BAndrews Alfred L · San Antonio, TXBuilt 1948 · S/N D-1411 N409BMorris Danny L · Woodland, CABuilt 1948 · S/N D-1414 N40URoss Stan W · Scandia, MNBuilt 1948 · S/N D-1336 N410BWright Samuel B · Haines, AKBuilt 1948 · S/N D-1607 N413BKc Beech Front Ltd · Kansas City, KSBuilt 1948 · S/N D-1419 N418BRobb Steven G · Riverside, CABuilt 1948 · S/N D-1424R8 N419EOlson Russell J · Garner, IABuilt 1948 · S/N D-1425 N420BRollison James · Scottsdale, AZBuilt 1948 · S/N D-1427 N423BCarlson Herb Trustee · Dana Point, CAS/N D-1430 N424BDenney Jody M · Mcminnville, TNS/N D-1598 N426BAnyones Home LLC · Enid, OKBuilt 1957 · S/N D-1647 N427BJennings Kenneth R · West Plains, MOBuilt 1948 · S/N D-1434 N431BKnisley David J · Jacksonville, FLBuilt 1948 · S/N D-1648 N433BOhlinger Mark A · Copley, OHBuilt 1948 · S/N D-1441 N439BSearuggs Quwan E · Houston, TXBuilt 1948 · S/N D-1447 N4434VAske Karl · Brainerd, MNBuilt 1947 · S/N D-1239 N4441Myal Walter J · Ruffs Dale, PABuilt 1950 · S/N D-2575 N4446VSahagun Salvador G · Bothell, WABuilt 1948 · S/N D-1256 N4451VBeicker Dennie L · Hernando, MSBuilt 1948 · S/N D-1266 N446BWyckoff Steven H · Lompoc, CABuilt 1948 · S/N D-1462 N4473VMoeller Brian C · Stewartville, MNBuilt 1948 · S/N D-1291 N4479VRegistration Pending · Haslet, TXRegistration pendingBuilt 1948 · S/N D-1297 N4487VMckenna Clark J · Big Rapids, MIBuilt 1948 · S/N D-1306 N4488VRegistration Pending · Houston, TXRegistration pendingBuilt 1948 · S/N D-1307 N4493VWeinheimer Ethan T · Onida, SDBuilt 1948 · S/N D-1313 N4501VRegistered aircraftS/N D-1322 N4504VWiley Calvin · Summer Shade, KYBuilt 1948 · S/N D-1325 N4512VDortch Steven D · La Vernia, TXBuilt 1948 · S/N D-1334 N4519VCarrell Samuel R · Knoxville, TNBuilt 1948 · S/N D-1342 N451BVan Velden Chris W · Yucaipa, CABuilt 1948 · S/N D-1776 N4525VMiller Grady F · Kingsland, TXBuilt 1948 · S/N D-1348

Back to AD 2002-21-13