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.

N456KMKilo Mike Aviation LLC · Chandler, AZBuilt 2006 · S/N 1977 N456LBPhoenix Aviation LLC · Dover, DEBuilt 2014 · S/N 2256 N456LEAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 1868 N456LL2fly-Safety LLC Trustee · Azle, TXBuilt 2008 · S/N 3009 N456MGJones Daniel S Trustee · Hendersonville, NCBuilt 2008 · S/N 3330 N456MKPiper Aircraft Inc · Vero Beach, FLS/N 4496657 N456PFCivic Aviation LLC · Miami, FLBuilt 1978 · S/N BB-413 N456RTMassive Solutions LLC Trustee · Denton, TXBuilt 2002 · S/N 0314 N456SSPowell Deidre · Santa Monica, CABuilt 2006 · S/N 1676 N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353 N4570ATamkin Steven M · Malibu, CABuilt 2006 · S/N 1717 N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039 N4573JRoss James A · Barrington, RIS/N 28R-30438 N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439 N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034 N457AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881757 N457ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010057 N457CAFox William B · Malvern, PAS/N 3160 N457CBPreferred Aviation Technologies LLC · Mooresville, NCBuilt 2008 · S/N 3058 N457FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10457 N457HRSummit Aviation Inc · Belgrade, MTBuilt 2006 · S/N 40.700 N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218 N457TLSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.572 N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045 N4581JN634mm LLC · Pelham, ALBuilt 1968 · S/N 28R-30450 N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042 N4582JTew-Mac Aviation · Tewksbury, MABuilt 1968 · S/N 28R-30451 N45832Arenal Patrick T · Granbury, TXBuilt 1977 · S/N 28-7890048 N4584FStorm Flying Service Inc · Webster City, IAFirst renewal noticeBuilt 1976 · S/N 28-7790047 N4584JBradley Cody C · Auburn, NEBuilt 1968 · S/N 28R-30454 N4585XFrost Aviation Services Inc · Las Cruces, NMBuilt 1975 · S/N 28-7690043 N4588JSierra Hotel Fliers LLC · Lexington Park, MDBuilt 1968 · S/N 28R-30459 N4589JArthurs Nathanael L · Indiana, PABuilt 1968 · S/N 28R-30462 N4589XSek LLC · Concordia, MOS/N 28-7690045 N458AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843799 N458ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010058 N458BBLeonard Aviation LLC · Ponte Vedra Beach, FLBuilt 2018 · S/N 4716 N458CAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0388 N458CPEagle Aviation LLC · Hawarden, IABuilt 2008 · S/N 3255 N458DSRao Dinesh · Ocala, FLS/N 40.1144 N458KDTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 4636762 N458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 28-43022 N458MMElly Aviation LLC · Boulder, COBuilt 2020 · S/N 2560 N458RHHamil Robert D · Houston, TXBuilt 2005 · S/N 1688 N458SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496490 N458TTTurner George T · Alpharetta, GABuilt 2004 · S/N 0801 N458TWFirst Aviation Co · Prospect Heights, ILBuilt 2003 · S/N 0697 N4590JEpic Aviation Inc · New Smyma Beach, FLBuilt 1968 · S/N 28R-30463 N4593XClubs 2 LLC · Calabasas, CABuilt 1975 · S/N 28-7690046 N4594F181 Corporation · Charlotte, NCBuilt 1976 · S/N 28-7790048

Back to AD 2008-06-28 R1