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.

N447AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8882 N447BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 4496581 N447BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496606 N447CHBruce Alexander Company LLC · Elkhart, INS/N 4697374 N447DLGlobal Control Systems Inc · Olathe, KSBuilt 2008 · S/N 4636436 N447DSAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 40.417 N447KCN447kc LLC · Mesa, AZS/N 3255047 N447MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 4496459 N447RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020197 N447SCN447sc LLC · Carmel, CABuilt 1989 · S/N 4622074 N44820Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816022 N44836Monadnock Aviation Inc · Keene, NHBuilt 1977 · S/N 28-7816025 N4483FHill Patrick E · Oceanside, CABuilt 1976 · S/N 28-7790031 N4483XBowers Gregory L · Greensboro, NCBuilt 1975 · S/N 28-7690020 N44847Hill David F · Pembroke, MABuilt 1977 · S/N 28-7816026 N44855Marshall Xavier T · Carson, CAS/N 28-7816028 N44858Swaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7816032 N4485FSaunders Raymond C III · Albuquerque, NMBuilt 1976 · S/N 28-7790033 N44872Allmond Aviation LLC · Peoria, ILBuilt 1977 · S/N 28-7816033 N44884Rsi Transportation LLC · Kalispell, MTS/N 28-7816037 N44886Personal Aviation Inc · Poway, CABuilt 1977 · S/N 28-7816038 N44898Andel Robert M · Milford, CTBuilt 1977 · S/N 28-7816040 N4489XFidelis Aviation LLC · Cornelius, NCBuilt 1975 · S/N 28-7690021 N448AWeeke Aviation LLC · Kalispell, MTBuilt 1998 · S/N 3257034 N448AMHetpath Aero LLC · Bismarck, NDBuilt 2015 · S/N 4205 N448AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8902 N448BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496607 N448CDKrebs Stephen P · Houston, TXS/N 1243 N448JAGood Flight Aviation LLC · Stockton, CABuilt 1996 · S/N 4496011 N448KGTondi David M · Sterling, VABuilt 1981 · S/N 32R-8113037 N448LMKinzler William · Tierra Verde, FLBuilt 2007 · S/N 2893 N448MAReynolds Roger David · Key West, FLBuilt 1998 · S/N 3257048 N448MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 4496518 N448RMPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020287 N448SRAquatic Resources Management LLC · Lexington, KYS/N 1048 N448STJames David W · Odessa, TXBuilt 2008 · S/N 4636448 N448TTScher Steven A · Sonoma, CABuilt 2008 · S/N 3073 N448USUtah State University · Logan, UTBuilt 2006 · S/N 40.708 N448ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881673 N44929Registered aircraftS/N 28-7816044 N44931H&R Aircraft Co LLC · Ward, ARBuilt 1977 · S/N 28-7816046 N44949Shoreline Aviation Inc · Marshfield, MABuilt 1977 · S/N 28-7816050 N4495FKitty Tango LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7790034 N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044 N4496FN4496f LLC · Provo, UTS/N 28-7790035 N4496XJennings Matthew · Valley Center, CAS/N 28-7690022 N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051 N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045 N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023 N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054

Back to AD 2008-06-28 R1