Skip to content

Registered aircraft · 22,430

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.

N16378Lapair Inc · Vero Beach, FLBuilt 1973 · S/N 32-7300026 N1637HGross Leslie W · Perry, MES/N 28-7716030 N16382Reick Gregg G · Minnesota City, MNBuilt 1973 · S/N 28-7325259 N16385Haines Michael C · Wadsworth, OHBuilt 1973 · S/N 28-7305242 N16387Anderson Jeffrey J · Hartland, WIBuilt 1973 · S/N 28-7310093 N1638HKaczmarek James J Jr · Parksley, VABuilt 1977 · S/N 28-7716032 N1638JSmith Bryan Alexander · Cabot, ARBuilt 1967 · S/N 28-24026 N16393Parker Owen · Collyer, KSBuilt 1973 · S/N 28-7325264 N16395Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1973 · S/N 28R-7335141 N16396Nobrainer Holdings LLC · Fort Lauderdale, FLBuilt 1973 · S/N 32-7300027 N16398Withers Harry R · Beaufort, SCBuilt 1973 · S/N 28-7305244 N1639JAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-24027 N163AMRogers Brian D · Pacific, MOBuilt 1968 · S/N 28-5009 N163AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010061 N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210 N163JTLifetime Investment Solutions LLC · Hahira, GABuilt 2005 · S/N 3232042 N163LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842362 N16402Peters Dale M · Naknek, AKBuilt 1973 · S/N 28-7305245 N16409Pridmore Joshua B · Lubbock, TXBuilt 1973 · S/N 28-7325265 N1640HArcher 1640h LLC · Oscoda, MIS/N 28-7790321 N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221 N16410Cherokee Five LLC · Bakersfield, CABuilt 1973 · S/N 28-7325266 N16412Cherokee N16412 LLC · Peoria, AZBuilt 1973 · S/N 28-7305247 N16415United Aviation LLC · Prospect, KYS/N 32-7340085 N16417Riddle Christopher Joseph · Auburn, CABuilt 1973 · S/N 28-7305249 N16418Hallgren Mitchel T · Sycamore, ILBuilt 1973 · S/N 28-7305250 N16422Ardupilot Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335145 N16425Box Aviation Inc · Montgomery, ALBuilt 1973 · S/N 28-7305251 N16429Hilbish David B · Chicago, ILBuilt 1973 · S/N 28R-7335112 N16430Lyons Larry A · Stockton, ILBuilt 1973 · S/N 28-7305252 N16433Pn4 Aviation Holdings LLC · Bishop, CABuilt 1973 · S/N 28-7325271 N16434Livingston Charles · Franklinville, NYS/N 28-7325273 N16435Gumms Leroy J · Perris, CAS/N 28-7305254 N16437Novawings Aviation LLC · Porter, TXS/N 28R-7335146 N1643HSiegenthaler Dean · Mineral Point, WIBuilt 1977 · S/N 32-7700011 N1643JDe Bry Daniel G · Dowagiac, MIS/N 28-24034 N16440Bolen Darin L · Murfreesboro, TNBuilt 1973 · S/N 28-7310097 N164412c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 32-7340087 N16446Cash Management Consulting LLC · Granite Springs, NYBuilt 1973 · S/N 28-7325274 N16447Cornejo Mauro R · Tucson, AZBuilt 1973 · S/N 28-7325276 N16448Lynch Timothy Christopher · Robbinsville, NJBuilt 1973 · S/N 28-7305256 N16449Cloud Nine Flying Club Inc · Fergus Falls, MNBuilt 1973 · S/N 28-7305257 N1644JTurner Colby · Lamar, COBuilt 1967 · S/N 28-24036 N16456Blackwell Jerry R · Jackson, TNBuilt 1973 · S/N 28-7305260 N16458Greenwood Flyers LLC · Kinards, SCBuilt 1973 · S/N 28-7305261 N16459Chase Charles D · Baskin, LABuilt 1973 · S/N 28R-7335150 N1645JWhite Jesse J · Penn Valley, CABuilt 1967 · S/N 28-24037 N16468Am Aviation LLC · University City, MOBuilt 1973 · S/N 28-7325279 N1646H3k Aviation LLC · Iron Station, NCS/N 28-7716033 N16484Johnson Training Institute LLC · Zachary, LABuilt 1973 · S/N 28-7305264

Back to AD 87-08-08 R3