Skip to content

Registered aircraft · 630

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-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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.

N8202RValiair Lc Trustee · Casper, WYBuilt 1972 · S/N 30418 N8206RWright Foy A Jr · Demopolis, ALBuilt 1971 · S/N 30406 N8207RAllen Robert L · Lenexa, KSBuilt 1972 · S/N 30449 N8210RChase Daniel E · Grand Rapids, MNBuilt 1972 · S/N 30421 N8213RHenley Charles D · New London, NCBuilt 1972 · S/N 30425 N8216RJoyce James A · Olathe, KSBuilt 1971 · S/N 30415 N8217RAj Management Inc · Spicewood, TXBuilt 1972 · S/N 30419 N8223RSuper Viking LLC · Ankeny, IABuilt 1971 · S/N 30407 N8226RHitchcock Jon E · Roswell, NMBuilt 1972 · S/N 30435 N8227RDudley Diana W · Creedmoor, NCS/N 30424 N8229RWaggoner Mark E · Saint Jo, TXBuilt 1971 · S/N 30408 N8236RBellanca LLC · Galena, KSS/N 32-67 N8239RBeilfuss Jeffery L · Jasper, GAS/N 30445 N8241ROkie Flyers LLC · Norman, OKBuilt 1972 · S/N 30444 N8243RJames Charles S · Canon City, COBuilt 1972 · S/N 30441 N8245RPella Michael J · Fargo, NDS/N 30452 N8249ZCustom Cattle Service LLC · Lakin, KSBuilt 1972 · S/N 30459 N824KLN824kl LLC · Lakewood, CABuilt 1973 · S/N 73-32-123 N8253RSalem Virgil J · Cimarron, KSBuilt 1972 · S/N 30440 N8254RKrejci Ryan J · Sandstone, MNBuilt 1972 · S/N 32-88 N8255RTwo River Airspray LLC · Cavalier, NDBuilt 1972 · S/N 32-72 N8257RPreiss Michael C · Southaven, MSBuilt 1972 · S/N 30450 N8258RNewo Aviation LLC · Garden City, KSS/N 32-66 N8262RReder Scott W · Fruitdale, SDBuilt 1972 · S/N 30442 N8265RMirrorstriker Aviation LLC · Tomball, TXBuilt 1972 · S/N 32-73 N8275RRensberger Scott C · Lake Jackson, TXBuilt 1972 · S/N 32-84 N8276RSeland David P · Gulfport, MSBuilt 1972 · S/N 30469 N8278RSutton Barry W · Longview, TXBuilt 1972 · S/N 32-82 N8281RDederick Ethan J · Kent, WABuilt 1972 · S/N 30464 N8282RTorrey Daniel B · Ojai, CABuilt 1972 · S/N 30468 N8285RLatimer Mark A · Vernon, TXBuilt 1972 · S/N 30466 N8287RHuhnke John · Newburgh, INBuilt 1972 · S/N 32-81 N8289RSebi Aviation Tt LLC · Austin, TXBuilt 1972 · S/N 30470 N8290RHunt George Richard · Bakersfield, CABuilt 1972 · S/N 30481 N8299RAde Doug · Frederick, OKBuilt 1972 · S/N 30457 N8522NVega Aviation Services LLC · Loxahatchee, FLBuilt 1973 · S/N 73-30610 N8544HLaw Offices Of Timothy E Nilan A Pro Law Corp · Downey, CABuilt 1970 · S/N 31010 N866DLHenry Kelly L · Meridian, IDBuilt 1973 · S/N 74-30623 N868CTPrivette Hugh T Trustee · Colorado Springs, COBuilt 1974 · S/N 74-30726 N872JWWheeler Jeffrey A · Elyria, OHBuilt 1972 · S/N 32-90 N8779VCockrell Tyler J · Clovis, NMBuilt 1970 · S/N 30316 N8783VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1971 · S/N 30361 N8784VSwanson Steven V · Saint Marys, GABuilt 1971 · S/N 31017 N8788VMitchell Robert D · Blackwell, OKS/N 30323 N8791VLambert Dorian · South Shore, KYS/N 30330 N8796VAnderson James D · Demopolis, ALBuilt 1971 · S/N 30364 N8798VPalmer Harvey F · Omaha, NEBuilt 1970 · S/N 31014 N87KTRabe Craig · Celina, TXBuilt 1986 · S/N 87-30997 N8800VLong Jon M · Santee, CABuilt 1973 · S/N 74-31085 N8803VNelson Grant V · Plymouth, MNBuilt 1971 · S/N 30335

Back to AD 87-11-01 R1