Registered aircraft · 25,368

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N9107HChm Aviation LLC · Wilmington, DEBuilt 1975 · S/N 17265948 N9107LJ P Aero Holdings Inc · Carson City, NVS/N 796-71 N91084Cropair Flying Service Inc · Cody, WYBuilt 1975 · S/N 18802020T N9109HJunior Coal Contracting Inc · Philipsburg, PABuilt 1975 · S/N 17265950 N9109LYellowbird LLC · Lititz, PABuilt 1970 · S/N 299-71 N910BUElika Aero LLC · Philadelphia, PABuilt 1983 · S/N 24-1406 N910DKUpside Down Holdings LLC · Sherman Oaks, CABuilt 2005 · S/N 1007-2005 N910PFCertified Aviation LLC · Morristown, NJBuilt 1974 · S/N 17263818 N9110HSierra Aero LLC · Truckee, CABuilt 1975 · S/N 17265951 N9112CCk Jet LLC · Hillsboro, MOBuilt 1978 · S/N R18200404 N9112LRockey Bruce G · Bitely, MIBuilt 1970 · S/N 263-71 N9113FReed Michael J · Paola, KSS/N 24-3180 N9113JHrivnak Michael J · Raleigh, NCBuilt 1990 · S/N 24-3181 N9113LZimin Carl E · Naknek, AKBuilt 1970 · S/N 300-71 N9113VBarry Dustin Michael · Highland, ILBuilt 1969 · S/N 690026 N9114HRohwer Michael G Trustee · Tucson, AZBuilt 1975 · S/N 17265952 N9114LKeller Crop Surveillance LLC · Jonesboro, ARBuilt 1970 · S/N 301-71 N9114VTayl Number Aero LLC · Tontitown, ARBuilt 1969 · S/N 690022 N9114YSpirit Aero LLC · New Melle, MOBuilt 1990 · S/N 24-3183 N91152Dt Pralle Enterprise Inc · Hampton, IABuilt 1975 · S/N 18802022T N9115LSavonen Stephen D · Ukiah, CABuilt 1970 · S/N 797-71 N9115VBovo Paolo · San Benito, TXBuilt 1969 · S/N 690027 N9115ZK & C Publications LLC · Spring Valley, OHBuilt 1990 · S/N 24-3184 N9116LShowers Of Blessings LLC · Fredericktown, MOBuilt 1970 · S/N 302-71 N9117CRegistered aircraftBuilt 1978 · S/N R18200408 N9117LWillkris Aviation Services LLC · Smithfield, VAS/N 303-71 N9117VEdgerton Bruce M · Ottsville, PABuilt 1969 · S/N 690028 N9118CWalter Tina R · Yorkville, CABuilt 1978 · S/N R18200409 N9118LDavis Brett M · Madison, MEBuilt 1970 · S/N 305-71 N9119LPiercy Ronald S · Moses Lake, WABuilt 1970 · S/N 304-71 N9119VCarlson Tracy W · Henderson, NVBuilt 1969 · S/N 690006 N9119YHart Lawrence Mark · Albion, PABuilt 1992 · S/N 24-3265 N9119ZZulu Murphy LLC · Oklahoma City, OKBuilt 1994 · S/N 24-3341 N911MBHarry Thomas C · Boiling Springs, PABuilt 1966 · S/N 670042 N911PBaldwin Andrew W · Lander, WYBuilt 1971 · S/N 172-60321 N9120HKrieg Kristi · Tonasket, WAS/N 17265954 N9120LHarper Kevin J · Valley Center, KSBuilt 1970 · S/N 799-71 N9120PCanitz James Trustee · Eagle River, AKBuilt 1998 · S/N 24-3417 N9121HTwenty-One Flyers Inc · Norwalk, CTBuilt 1975 · S/N 17265955 N9121VDelta Tango Golf LLC · San Angelo, TXBuilt 1969 · S/N 690029 N9122VRobinson Brian K · Brownwood, TXBuilt 1969 · S/N 690024 N9123CRegistration Pending · San Bernardino, CARegistration pendingBuilt 1978 · S/N R18200411 N9123HTwenty Three Juliet LLC · Tyler, TXBuilt 1976 · S/N 17265957 N9123LAppold Dave J · Bay City, MIBuilt 1970 · S/N 804-71 N9125UConner Douglass C · Beaumont, TXBuilt 1990 · S/N 24-3179 N9125VLuymes Kirk M · Wessington Springs, SDBuilt 1969 · S/N 690030 N9126CBowers Gordon M · Chesterfield, VABuilt 1978 · S/N R18200412 N9126LHager David L · Barney, NDBuilt 1971 · S/N 308-71 N9127DDepasquale Chad E · Glastonbury, CTS/N 24-3190 N9127HMoraine Flying Club Inc · Butler, PABuilt 1975 · S/N 17265959

Back to AD 80-25-07 R1