Skip to content

Registered aircraft · 22,416

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

N726BBStater Christopher B · Charlotte, NCBuilt 1986 · S/N 2811003 N726DFTactical Aviation LLC · Brownstown, MIBuilt 1981 · S/N 28-8216023 N726GJBeran James · Mahwah, NJBuilt 1980 · S/N 328024047 N726NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881488 N7270JJones Frederick W · Burgaw, NCS/N 28-24610 N7270WEast West Aviation Club · DuffelS/N 28-1105 N7271CChesley James Philip · Mesa, AZBuilt 1975 · S/N 28R-7635098 N7274JFairway Chalet LLC · San Antonio, TXS/N 28-24617 N7274WSky & Sea Horizons LLC · Memphis, TNBuilt 1965 · S/N 28-2895 N7275JAmon Mccrary Bryley · Bullard, TXBuilt 1968 · S/N 28-24618 N7275LLaughlin Jonathan · Rich Hill, MOBuilt 1965 · S/N 28 2405 N7275WHinkley Dean E · Sun City, FLBuilt 1963 · S/N 28-1111 N7276JWheeler Kelly E · Columbia Falls, MTBuilt 1968 · S/N 28-24619 N7276WFlyright Aviation LLC · Plymouth, MNBuilt 1963 · S/N 28-1114 N7277WOrganic Media Studio LLC · Hattiesburg, MSBuilt 1963 · S/N 28-1146 N7278CAndrews Jeb C · Monroe, LABuilt 1975 · S/N 32R-7680044 N727ACLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 28-7890128 N727AJMeyer Joshua · Fairborn, OHBuilt 1968 · S/N 28-24624 N727BHPiper 7bh LLC · Middleton, MABuilt 1974 · S/N 28-7415464 N727DEKennett Aerospace LLC · Kennett, MOBuilt 1978 · S/N 28-7816572 N727FLOgilvie Danny L · Yucca Valley, CABuilt 1972 · S/N 28-7225431 N727GRParth Aviation LLC · Terre Haute, INBuilt 2006 · S/N 3246238 N727HALinfield Steven J · Westminster, MDBuilt 1978 · S/N 28R-7803289 N727HSSandstar Aviation LLC · Lewes, DES/N 28R-7335432 N727PGDowns Donald S · Lake City, FLBuilt 1977 · S/N 28R-7703227 N727SDStable Air LLC · Leonardtown, MDBuilt 1976 · S/N 32R-7780060 N7280CGriff Air LLC · Aurora, ORBuilt 1975 · S/N 28-7625074 N7280FHarmon Sharon O · Pasco, WAFirst renewal noticeBuilt 1968 · S/N 28-25192 N7281JBilbrey Don R · Georgetown, OHBuilt 1968 · S/N 28-24626 N7282JWirth Alan Patrick · Callaway, MDBuilt 1968 · S/N 28-24629 N7282WHoracio Marcelo Knop · Hialeah, FLS/N 28-1122 N7284CSeed Richard J IV · Wicomico Church, VAS/N 28R-7635099 N7284JGiermek Peter T · Olean, NYBuilt 1968 · S/N 28-24631 N7285FKulp Clayton H · Wichita, KSS/N 28-25198 N7286CWalker David L · Louisville, KYFirst renewal noticeBuilt 1975 · S/N 28-7610048 N7286WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1126 N7287JJames Leroy R · Renfrew, PABuilt 1968 · S/N 28-24638 N7287WLebouef Kelly J · Rayne, LABuilt 1963 · S/N 28-1131 N7288FJ&S Aeronautics LLC · Mcgregor, TXBuilt 1968 · S/N 28-25202 N7288WIndependence Youth Flying Club Inc · Independence, ORBuilt 1963 · S/N 28-1132 N7289JValdez Jose C · Troy, MIBuilt 1968 · S/N 28-24641 N7289WHarris Clark R · Tribune, KSBuilt 1963 · S/N 28-1133 N728AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843791 N728BLRamey Dale J · Atascadero, CABuilt 1968 · S/N 28-11174 N728FLFalcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedS/N 28-7225448 N728NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843886 N728SJHighland Aviation LLC · Flagstaff, AZBuilt 1981 · S/N 32R8129011 N728TBAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816536 N728WFReigh Galen R · Williamsburg, PABuilt 1979 · S/N 28-7916371 N7290JPiper Nicolas A M · Atherton, CABuilt 1968 · S/N 28-24642

Back to AD 87-08-08 R3