Skip to content

Registered aircraft · 40,394

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

N941MPHill John D · Reno, NVBuilt 1956 · S/N 22-4433 N941TWHodge Flight Services LLC · Pittsburg, CABuilt 1981 · S/N 17275446 N9420EAero Quest LLC · Costa Mesa, CABuilt 1979 · S/N 17272256 N9420VAerologic LLC · Yorktown, VABuilt 1969 · S/N 700040 N9421DJeff Air Pilot Services LLC · Shelbyville, INBuilt 1984 · S/N 172RG1154 N9421EStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N 17272257 N9421JSmith Robert Martin Jr · Port Saint Lucie, FLBuilt 1966 · S/N 28-3532 N9423JDt Pralle Enterprise Inc · Hampton, IABuilt 1966 · S/N 28-3534 N9423VLevin Robert G · Roseburg, ORS/N 700041 N9424DBranch Clayton L · Winfield, KSBuilt 1958 · S/N 22-6398 N9424EAero Equities LLC · Ventura, CABuilt 1979 · S/N 17272259 N9425HWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17266153 N9425JWachusett Flying Club Inc · Princeton, MABuilt 1966 · S/N 28-3536 N9425VEcaviators LLC · Wilmington, DES/N 700042 N9426EDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 17272261 N9426J4hx LLC · Dallas, TXBuilt 1966 · S/N 28-3537 N9427VBrack Enterprises LLC · Indianapolis, INBuilt 1970 · S/N 700053 N9428WHodge Steve · Denison, TXBuilt 1971 · S/N 28-7125150 N9429VFrankel Daniel A · Madison, OHBuilt 1969 · S/N 700044 N942BBSeibert Joseph John · Cincinnati, OHS/N 10339 N942CABaca Flavio Tomas · Vail, AZBuilt 1966 · S/N 28-3304 N942FLJochnma Steven J · Aumsville, ORBuilt 2001 · S/N 90042 N942LBWade Ronald · Lake Stevens, WABuilt 2010 · S/N 70801 N942TBillen Jarod H · Lakeland, TNBuilt 1960 · S/N TD-363 N942TBBailey Thomas R · Benton, KYBuilt 1963 · S/N 2587 N942TECardinal Enterprise LLC · Jackson, WYBuilt 2003 · S/N 10221 N942VTMcintosh Donald W · Sandpoint, IDBuilt 2010 · S/N 942 N9431COsgood Air LLC · Ransom, KSBuilt 1978 · S/N 28-7890411 N9431JCurrie Kenneth Edward · Lumberton, NCBuilt 1966 · S/N 28-3542 N9432DRegistered aircraftBuilt 1984 · S/N 172RG1160 N9433DPacer Flight LLC · Huron, OHBuilt 1958 · S/N 22-6407 N9433EKozma Peter · San Diego, CABuilt 1979 · S/N 17272264 N9433JSierra Delta Aviation Services Inc · Middletown, DEBuilt 1966 · S/N 28-3545 N9433LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276556 N9434JSchmidt Matthew F · River Falls, WIBuilt 1966 · S/N 28-3546 N9434VKnackstedt Dennis R · Winfield, KSBuilt 1970 · S/N 700046 N9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeBuilt 1981 · S/N 172RG0821 N9435JHarmon Daniel J · Sheridan, INBuilt 1966 · S/N 28-3547 N9437DRichmor Aviation Inc · Scotia, NYBuilt 1984 · S/N 172RG1161 N9437JGarba Ibrahim I · Boulder City, NVBuilt 1966 · S/N 28-3549 N9438DWeidner Kevin G · Bunker Hill, ILBuilt 1958 · S/N 22-6412 N9438HBering Capital LLC · Anchorage, AKS/N 17266155 N9438VPrestridge Jacob · Portland, ORS/N 700071 N9439BAv Dak Inc · Crystal, NDBuilt 1981 · S/N 172RG0822 N9439ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1979 · S/N 17272265 N9439HTreichler Peter DBA · East Aurora, NYBuilt 1964 · S/N 6 N9439KAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1976 · S/N 28-7625180 N943KSStark James E Trustee · Sun City, AZBuilt 1978 · S/N 17270273 N943RVShea Tim M · Pearland, TXBuilt 1993 · S/N JB 2644 N943TEZbikowski Scott · Lino Lakes, MNBuilt 2003 · S/N 10222

Back to AD 79-10-03 R2