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.

N385CPAttila Roka · Elkhorn, NEBuilt 2007 · S/N 1879 N385DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843847 N385DEDestinations Efc LLC · Tulsa, OKBuilt 2024 · S/N 9991 N385DSSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 2008 · S/N 40.1038 N385GTHighland Smiles LLC · Marietta, GABuilt 2024 · S/N 9979 N385HPAgri-Land West LLC · Newton, NCBuilt 2007 · S/N 3257467 N385KCChang Bill K · Friendswood, TXBuilt 2008 · S/N 4697385 N385SRMcmonigle And Associates LLC · Washington, DCBuilt 2006 · S/N 2256 N385TSTexas Southern University · Houston, TXBuilt 2025 · S/N 10696 N38603Flight Share LLC · Charlotte, NCBuilt 1977 · S/N 28-7790570 N3860TTds Property Holdings LLC · Gilmer, TXBuilt 1967 · S/N 28R-30183 N38628Maxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7790572 N38629Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1977 · S/N 28-7790573 N3862MN3862m LLC · Provo, UTS/N 28-7890337 N3862THanson John M · Wht Sphr Spgs, MTBuilt 1967 · S/N 28R-30185 N3864MAscent Aviation LLC · Van Nuys, CABuilt 1978 · S/N 28-7890338 N3864TPatton Aviation LLC · Billings, MTBuilt 1967 · S/N 28R-30187 N38656Allen James R · Olympia, WABuilt 1977 · S/N 28-7716272 N38657W I F A (Washington International Flight Acad) LLC · Gaithersburg, MDBuilt 1977 · S/N 28-7790574 N3866TVacracos James L · Saint John, INBuilt 1967 · S/N 28R-30189 N3867TSater Travis D · Salem, ORBuilt 1967 · S/N 28R-30190 N38694Chapman Daniel H · Yucaipa, CABuilt 1977 · S/N 28-7790576 N38696Lake Area Technical College · Watertown, SDBuilt 1977 · S/N 28-7790577 N3869TSix Niner Tango LLC · Spartanburg, SCBuilt 1967 · S/N 28R-30193 N386AVWestwind School Of Aeronautics Phoenix · Goodyear, AZBuilt 2025 · S/N 4496614 N386CKRiggs Russell · Sedalia, COBuilt 2009 · S/N 3473 N386DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843848 N386DEDestinations Efc LLC · Tulsa, OKBuilt 2024 · S/N 9904 N386DSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2010 · S/N 40.1106 N386JPSky Safety Inc · San Antonio, TXS/N 40.386 N386MAK2 Aviation LLC · Greenwood Village, COS/N 40.449 N386NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881678 N386RRProspective Management LLC · Ann Arbor, MIBuilt 2006 · S/N 2262 N386STWwc Sky Holdings LLC · Wilmington, DEBuilt 2025 · S/N 4636868 N386TSTexas Southern University · Houston, TXBuilt 2025 · S/N 10700 N38700Universal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 28-7890001 N3870TEast Coast Autoline LLC · Whitehall, PABuilt 1967 · S/N 28R-30194 N3871TSzd Property Management LLC · Oceanside, CABuilt 1967 · S/N 28R-30195 N3872TTucker Zane Griffin · Albany, ORBuilt 1967 · S/N 28R-30196 N38733Lauren Erick · Hollister, CABuilt 1977 · S/N 28-7790580 N38735Schulz Lewis E III · Sand Springs, OKBuilt 1977 · S/N 28-7790581 N3873TDerby City Aviation LLC · Vero Beach, FLBuilt 1967 · S/N 28R-30197 N3874TSmith Albert G Jr · Lake Jackson, TXBuilt 1967 · S/N 28R-30199 N3875TMichael Jin · Renton, WABuilt 1967 · S/N 28R-30200 N38777Medsker Doug S · Graham, MOBuilt 1977 · S/N 28-7816181 N38786Johnson David M · South Deerfield, MABuilt 1977 · S/N 28-7790588 N3878TRoach Keith E · Chester, SCBuilt 1967 · S/N 28R-30203 N3879TDupuis Kevin P · Waddell, AZBuilt 1967 · S/N 28R-30204 N387CARegistration Pending · Goldthwaite, TXRegistration pendingBuilt 2007 · S/N 40.810 N387CPSia Aviation LLC · Princeton, NJBuilt 2007 · S/N 1880

Back to AD 2008-06-28 R1