Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N461BBFlite Level Zero LLC · Stanfield, ORBuilt 2000 · S/N 4697016 N461CDRiver City Leasing LLC · Lakeville, MNBuilt 2004 · S/N 1189 N461DSHussey Neil A · Alton, NHBuilt 2007 · S/N 40.761 N461EDp Aviation LLC · Nixa, MOBuilt 2007 · S/N 2717 N461FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020061 N461JADesign Builds LLC · West Point, VABuilt 2003 · S/N 4697168 N461MBVeil Casey J · Jamestown, NDBuilt 2002 · S/N 3257302 N461PTaunus Partners Inc · Farmingdale, NYBuilt 2023 · S/N 9293 N461SBHeathman Planting Co · Indianola, MSBuilt 2012 · S/N 4636525 N461SRRiechers Peter Trustee · Napa, CABuilt 2007 · S/N 2604 N461TBTambry Ventures LLC · Happy Valley, ORBuilt 2010 · S/N 4636473 N4621JSudor Janet · Lancaster, PABuilt 1968 · S/N 28R-30506 N4623JBrockway Jack E · Enumclaw, WABuilt 1968 · S/N 28R-30509 N4624JCook Jerald W · Ariton, ALBuilt 1968 · S/N 28R-30510 N4625JWhittington David D · So Ogden, UTBuilt 1968 · S/N 28R-30511 N4626JMoonshiner Aviation LLC · Austin, TXBuilt 1968 · S/N 28R-30513 N4628JSix Drew · Clinton, OHBuilt 1968 · S/N 28R-30515 N462ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010062 N462CDSouth Fork Group LLC · Belmont, NCBuilt 2005 · S/N 1546 N462CPPonozzo Donald A · Plainwell, MIBuilt 2008 · S/N 3275 N462FAStratus Pr LLC · New Castle, DEBuilt 2022 · S/N 28020062 N462HPPrescott Healthcare LLC · Prescott, AZBuilt 2000 · S/N 4636285 N462HSAmelia Ann Cruzing LLC · Sibley, LABuilt 2003 · S/N 0775 N462LTSilber Justin A · Atlanta, GABuilt 1996 · S/N 4636056 N462MWest Bay Management LLC · Gardnerville, NVBuilt 2011 · S/N 4697462 N462PAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010043 N462PJFacklair LLC · Granville, OHS/N 4697249 N462PT4888 Aviation LLC · Peachtree Corners, GABuilt 2015 · S/N 4282 N462PWWhalen James D · Avon, CTBuilt 2024 · S/N 9858 N462THIndiana State University · Terre Haute, INBuilt 2009 · S/N 40.1056 N462TMPalisades Creek Aircraft Co LLC · Thayne, WYBuilt 1989 · S/N 4622029 N4631JMiller Family Enterprises LLC · Humble, TXBuilt 1968 · S/N 28R-30518 N4632FG & M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790051 N4632JMckellar Todd R · Ridgecrest, CABuilt 1968 · S/N 28R-30519 N4635JN4942d LLC · Greenfield, NHS/N 28R-30523 N4636FWilkens Wesley J · Watertown, SDBuilt 1976 · S/N 28-7790052 N4637JVijayan Priya · Mckinney, TXBuilt 1968 · S/N 28R-30526 N4638JChappel Dexter A · Palm Coast, FLBuilt 1968 · S/N 28R-30527 N463AMOcean Aviation Holdings LLC · Miami Gardens, FLBuilt 1977 · S/N 4636770 N463FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020063 N463HPBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4636335 N463JPJj Hughes Logistics LLC · Canyon, TXBuilt 1999 · S/N 4636216 N463KCCalm Air Aviation LLC · Norfolk, NEBuilt 2007 · S/N 4636412 N463THIndiana State University · Terre Haute, INBuilt 2009 · S/N 40.1058 N4641JN4641j LLC · Mulberry, FLBuilt 1968 · S/N 28R-30531 N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538 N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539 N4648JTutt Bryan · Louisville, KYS/N 28R-30542 N464ACBlack River Company LLC · Memphis, TNS/N 1816 N464AGMagnum Management Corp · Pleasant Grove, UTBuilt 2006 · S/N 41574

Back to AD 2008-06-28 R1