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.

N3099RMesserschmidt Brent L · Gainesville, GABuilt 1969 · S/N 28R-35668 N3099UCotter William P · Elkhart, KSBuilt 1963 · S/N 17250699 N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561 N3099YPerkins Scott B · Thomas, OKFirst renewal noticeBuilt 1962 · S/N 18254099 N309BDavis Kaylee · Port Orange, FLBuilt 1956 · S/N D-4715 N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309 N309FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020109 N309FFAgee Greg · Huntington, WVBuilt 1977 · S/N 28-7790492 N309MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010015 N309MMDavenport James M II · Hollywood, FLBuilt 1975 · S/N 17265518 N309NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881781 N309PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 2843508 N309WPMcmahon Peter · Brookfield, CTBuilt 1961 · S/N 24-2955 N30AEKetting Case H · College Place, WABuilt 1962 · S/N JH-167 N30AWKnox Tommy J · Lampasas, TXBuilt 1974 · S/N 18502369 N30BMagill Terry K · Beach City, TXBuilt 1966 · S/N 30-1381 N30CAState Of California Department Of Transportation · Sacramento, CABuilt 1974 · S/N CE-508 N30CMBoardman Air Service LLC · Henderson, NEBuilt 1974 · S/N 18502443 N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022 N30CTLaidley Robert F · Erie, COBuilt 1978 · S/N 182-66446 N30CWBrownd Gregory H · Shallowater, TXBuilt 1958 · S/N D-5636 N30DBBouchard Dean · Glendive, MTBuilt 1965 · S/N 17252702 N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536 N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006 N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229 N30EBowker Mark S · Bowdoinham, MES/N D-2475 N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076 N30EGPlane Fun Inc Tr Trustee · Snellville, GAS/N 345 N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266 N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412 N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59 N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913 N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203 N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410 N30GEEagle Air Inc · Schoolcraft, MIBuilt 1976 · S/N 18265130 N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470 N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079 N30HDRegistered aircraftS/N 21063234 N30HMHutchinson Brion M · Crowley, TXBuilt 1954 · S/N D-3853 N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043 N30JNDls Holdings Inc · Lewes, DEBuilt 1957 · S/N 30-1423 N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100 N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539 N30KDHolmander John D · East Greenwich, RIS/N E-3502 N30KJCrist Carry R · Crete, NEBuilt 1957 · S/N D-5181 N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018 N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122 N30LLSoftware Innovations LLC · Wahoo, NEBuilt 1982 · S/N TJ-391 N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995 N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098

Back to AD 98-21-21 R1