Skip to content

Registered aircraft · 22,411

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-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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.

N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374 N192PPiper Aircraft Inc · Vero Beach, FLS/N 28020294 N192SKDelta Ssm Holding Co · Gladstone, MIS/N 2811022 N1930TWing John · Fort Worth, TXS/N 28-7125442 N1933HBlock Andrea · Chandler, AZS/N 28-7725170 N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151 N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065 N1935TWebboe Investments LLC · Falls Church, VABuilt 1971 · S/N 287105153 N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066 N1936SMoore Christopher D · Cheyenne, OKBuilt 1964 · S/N 28-3173 N1936TN1936t LLC · Franklin Park, NJBuilt 1971 · S/N 28-7105154 N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358 N1937KGriffin Contracting Co · Bloomfield, MOS/N 3213091 N1937TChristianson Eric L · Peoria, AZBuilt 1971 · S/N 28-7125490 N1939GMorgan Larry D · Blair, NEBuilt 1989 · S/N 2890107 N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018 N193LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010067 N193MBSmith Paul A · Trufant, MIBuilt 1979 · S/N 28-7911104 N193WMCarter Jason W · Owens Cross Roads, ALBuilt 1970 · S/N 28-5795 N1940TC140 Co LLC · Milton, FLBuilt 1971 · S/N 28R-7135138 N1941VSale Reported · Bloomburg, TXSale reported, canceledBuilt 1984 · S/N 28-8490056 N1942JFlybird LLC · East Northport, NYBuilt 2003 · S/N 3246216 N1942TGullion Monte C · Scottsburg, INBuilt 1971 · S/N 28-7105155 N1942ZThird Step 5 LLC · Gilbert, AZS/N 28-22849 N1943TFuhrman Ronald A · Fargo, NDBuilt 1971 · S/N 28-7105156 N1944TBeen Flying LLC · Colchester, CTBuilt 1971 · S/N 28-7125497 N1945TPatterson John W · Stockton, CABuilt 1971 · S/N 28-7125506 N1946HMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716067 N1946TDja Aviation LLC · Middletown, DEBuilt 1971 · S/N 28R-7135140 N1948TAshely Jane E · Midlothian, TXS/N 28-7125451 N194GSMaster Aviation LLC · Intl Falls, MNBuilt 2022 · S/N 2881515 N194HPHighwood Consulting Group Inc · Bedford, NHBuilt 1993 · S/N 3213043 N194MAJb Air Inc · Manhattan, KSBuilt 2001 · S/N 3246194 N194RJSmith Collin C · Bakersfield, CABuilt 1966 · S/N 28-2760 N1952HAmpersand Air Inc · Camp Hill, PABuilt 1977 · S/N 28R-7703041 N1952TLeardo Inc · Plano, TXS/N 28R-7135185 N1953HBritton Scott M · Fairview, TXBuilt 1977 · S/N 32-7740044 N1953TDaniella Levi & Associates Pc · Fresh Meadows, NYBuilt 1971 · S/N 28-7105190 N1954TDmac Aircraft LLC · Savannah, GABuilt 1971 · S/N 28-7105191 N1955HDriskell Cpa Firm Pc · Birmingham, ALBuilt 1977 · S/N 32R-7780209 N1956SRegistered aircraftBuilt 1975 · S/N 28R-7535164 N1957TPipers Are Still Better LLC · Carson City, NVBuilt 1971 · S/N 28R-7135177 N1959HN1959h Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28-7790361 N195AJ195aj LLC · Toledo, OHBuilt 1995 · S/N 3213096 N195MASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881029 N195PJSwif LLC · Atlantic, IABuilt 1978 · S/N 32-7840092 N1960TRay Steven B · Fort Collins, COBuilt 1971 · S/N 28R-7135173 N1961JCullen Stephen · Washington, INBuilt 1978 · S/N 28-7890476 N1962TPinnacle Plane Company LLC · Aberdeen, NCS/N 28-7105196 N1963HKacademic Engineering LLC · Dover, DEBuilt 1977 · S/N 28-7710010

Back to AD 87-08-08 R3