Registered aircraft · 85,612

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N3065VEvans Bruce E · Aztec, NMBuilt 1947 · S/N D-479 N3065ZDreiling Alexander R · Queen Creek, AZBuilt 1979 · S/N 28R-7918124 N3066APrice Brian · Page, AZS/N 25710 N3066BAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1987 · S/N TH-1514 N3066CBarham Micheal · Bluffton, OHBuilt 1958 · S/N D-5719 N3066DN3066d LLC · Pompano Beach, FLBuilt 1998 · S/N TH-1866 N3066GAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7990197 N3066HLarsen Mark S · Spencer, IABuilt 1978 · S/N 28-7916219 N3066KQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7918005 N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984 N3066QMeyer Vernon C · Westlake, LABuilt 1967 · S/N 18258066 N3066RParker Michael A · Milwaukee, WIBuilt 1969 · S/N 28R-35628 N3066UAjh Aviation LLC · Monroe, LABuilt 2004 · S/N 3257341 N3066YQuiett Aaron Trustee · Hillsboro, ORS/N 28-7990392 N3066ZBate Edward F III · Rhome, TXBuilt 1979 · S/N 28R-7918125 N3067AHanson Lavon T · Huson, MTS/N 25711 N3067CGoncharov Serge S · Monroe, NCBuilt 1958 · S/N D-5731 N3067DLawson Roger E · Elizabethtown, KYBuilt 1978 · S/N 28-7916159 N3067KLynch Alan J · Auburn, WABuilt 1978 · S/N 28R-7918006 N3067QKpw Enterprises Inc · Chula Vista, CABuilt 1977 · S/N 32R-7780279 N3067RSmith Julia L · Big Bear City, CABuilt 1969 · S/N 28R-35627 N3067TLandsberg Bruce S · Mount Pleasant, SCBuilt 1987 · S/N E-2368 N3067YRegistration Pending · Bluffdale, UTRegistration pendingBuilt 1962 · S/N 18254067 N30689Pung Larry J · Hermitage, TNBuilt 1978 · S/N 32R-7885282 N3068ACyrus Ely G · Kiana, AKS/N 25712 N3068FLehrman Walter M · Reedley, CABuilt 1966 · S/N 18257168 N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068 N3068QTurbo Arrow IV LLC · Nibley, UTBuilt 1979 · S/N 28R-7931074 N3068RIsland Aero LLC · Kailua, HIFirst renewal noticeBuilt 1969 · S/N 28R-35629 N3068THomeyer Joanne · Alexander, ARBuilt 1979 · S/N 32R-7987111 N3068UArlins Aircraft Service Inc · Belgrade, MTBuilt 1963 · S/N 17250668 N3068VBurgin Lee · Borger, TXS/N D-482 N3068WSneebler Transport LLC · Burke, VABuilt 1973 · S/N E-490 N30697Rl Flyers LLC · Dover, DEBuilt 1978 · S/N 32-7840124 N3069CBusboom Richard Jay · Berthoud, COBuilt 1978 · S/N 28-7990153 N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269 N3069FBlaine Barry A · Campbell, CABuilt 1966 · S/N 18257169 N3069LGrech George A Trustee · Concord, CABuilt 1979 · S/N 28-7990263 N3069QMarin Alberto · Mc Neal, AZS/N 18258069 N3069RBean Sheila L · San Antonio, TXBuilt 1969 · S/N 28R-35630 N3069TTop Tier Truck And Trailer LLC · Amarillo, TXS/N 32R-7987112 N3069YSeufer Trevor Scott · Wrightstown, NJBuilt 1979 · S/N 28R-7918104 N306AKRobinson Thomas F II · Port Charlotte, FLBuilt 1966 · S/N 30-1253 N306BWoodward Michael W · Mount Erie, ILBuilt 1956 · S/N D-4675 N306DFBrault Greg T · Othello, WAS/N 32R-8129103 N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544 N306GWCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 17250714 N306HACharlie Group LLC · Dover, DES/N 28-7715188 N306LJAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881496 N306LTSteiner Glenn C · San Jose, CAFirst renewal noticeBuilt 1974 · S/N 32-7340111

Back to AD 98-21-21 R1