Skip to content

Registered aircraft · 22,416

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.

N9453WLifetime Aviation Services LLC · Muncie, INBuilt 1969 · S/N 28-11172 N9454CPuglia Frank V · El Cajon, CABuilt 1978 · S/N 28-7816477 N9455NSchreiber Jeffrey H · Mundelein, ILBuilt 1969 · S/N 28R-35170 N9456WEngwis Douglas R · Rhodes, MIBuilt 1969 · S/N 28-11175 N9457NHermes Aviation Partners LLC · Boca Raton, FLBuilt 1969 · S/N 28R-35172 N9457WMast Henry V · Dayton, TXBuilt 1969 · S/N 28-11177 N9458JTibbitts Dennis C · Woodstock, ILBuilt 1966 · S/N 28-3571 N9458NSwaz Aviation LLC · Mesa, AZBuilt 1969 · S/N 28R-35174 N9459NEngel Stephen J · Plymouth, INBuilt 1969 · S/N 28R-35175 N945DBHoskins Joshua C · Frisco, TXBuilt 2000 · S/N 2843312 N945DSKnox Matthew · New Carlisle, OHBuilt 1962 · S/N 28-620 N945JKSweetair Aviation · West Monroe, LABuilt 1971 · S/N 32-7140039 N945LBAllegro Jeff · Upper Lake, CABuilt 1979 · S/N 28-7990404 N9460JDerosa Michael D · Hewitt, TXBuilt 1966 · S/N 28-3573 N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412 N9461JKobbeman Joseph B · Louisville, KYBuilt 1966 · S/N 28-3574 N9461NJames Neville & Company Inc · Ocala, FLBuilt 1969 · S/N 28R-35177 N9462NLombardo Gene S · New Bern, NCBuilt 1969 · S/N 28R-35178 N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253 N9463WHassebroek Leroy A · Little Rock, IABuilt 1968 · S/N 28-11186 N9464JReinert Roger J · Duluth, MNS/N 28-3578 N9464NTempleton Katherine M · Madison, WIBuilt 1969 · S/N 28R-35180 N9464WHollingsworth Ronald W · Shawnee, KSBuilt 1968 · S/N 28-11187 N9465JTaylor Robert J · Woodbridge, VABuilt 1966 · S/N 28-3579 N9465NStenhouse Place I LLC · Fountain Inn, SCBuilt 1969 · S/N 28R-35181 N9466JHawk Aviation Academy LLC · Saint Petersburg, FLBuilt 1966 · S/N 28-3580 N9466KSpanaflight LLC · Puyallup, WABuilt 1976 · S/N 28R-7635244 N9466NWingert Douglas L · Smithfield, KYBuilt 1969 · S/N 28R-35182 N9466WDisorbo Stephen S · New Milford, CTBuilt 1968 · S/N 28-11190 N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413 N9467WHartshorn Brian · Waynesville, OHBuilt 1968 · S/N 28-11192 N9468JSheffield Glenn A · Houston, TXBuilt 1966 · S/N 28-3582 N9469JNelson Stephen A · Milaca, MNBuilt 1966 · S/N 28-3584 N9470NEdwards Ed · Collinsville, OKS/N 28R-35187 N9470WRegistration Pending · Cortez, CORegistration pendingBuilt 1968 · S/N 28-11196 N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200 N9471WMidway Enterprises Inc · Wilmington, DES/N 28-11198 N9472CRhoads Timothy C · Logan, NMBuilt 1978 · S/N 28R-7803260 N9472JMarquette County Flying Club · Marquette, MIBuilt 1966 · S/N 28-3587 N9472WSelvaraj Mylappan · Butler, PABuilt 1968 · S/N 28-11199 N9473JEncounter Inc · Piedmont, OKBuilt 1966 · S/N 28-3588 N9473WRohrer Stephen B · Decatur, GABuilt 1969 · S/N 28-11202 N9474JGerber Dennis J · Liverpool, NYBuilt 1966 · S/N 28-3589 N9474NA-G-E Corp · Fort Pierre, SDS/N 28R-35191 N9474WGoines Russel D · Highland, CABuilt 1968 · S/N 28-11204 N9475WGiese Aerial Inc · Hoffman, MNBuilt 1968 · S/N 28-11205 N9476JNery Thomas A · Mansfield, MABuilt 1966 · S/N 28-3592 N9476NScheigert Delbert F Jr · Tucson, AZBuilt 1969 · S/N 28R-35193 N9477JMatthews Byron Kim · Hooper, UTS/N 28-3593 N9477WBaker John E · Westfield Center, OHBuilt 1968 · S/N 28-11210

Back to AD 87-08-08 R3