Registered aircraft · 826

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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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.

N95KPPainter Kenneth Lee · Luray, VABuilt 1973 · S/N 119-73 N95PBExtreme Air LLC · Santa Barbara, CABuilt 2024 · S/N 1213-2024 N95PUTrustees Of Purdue University · West Lafayette, INS/N 1037-2007 N960RMCag International Inc DBA · Longmont, COBuilt 2000 · S/N 852-99 N962ACMccrary Ryan Michael · Greensburg, INBuilt 2001 · S/N 877-2000 N963TTAmerican Capital Aviation LLC · Kalispell, MTBuilt 2020 · S/N 1189-2020 N964SEGray Luke Francis · San Bruno, CABuilt 2004 · S/N 964-2004 N965MAFirst Aero Group LLC · Wilmington, DEBuilt 2004 · S/N 967-2004 N969AAFlight Path LLC · Egg Harbor City, NJBuilt 2021 · S/N 1191-2021 N96WWDragging Tails LLC · Madison, MSBuilt 2001 · S/N 888-2001 N972DDarcy Cathy S · Wayzata, MNBuilt 2014 · S/N 1138-2014 N97ACReber Tim · Terrace Park, OHBuilt 1993 · S/N 706-93 N97FZRegistered aircraftBuilt 1997 · S/N 79697 N97PBlack River Construction Services LLC · Black River Falls, WIBuilt 2001 · S/N 881-2001 N981DCMerten Aviation Services LLC · Holtville, CAS/N 1085-2009 N987ANf County Flying Club Inc · Chateaugay, NYBuilt 2003 · S/N 921-2003 N989CDDoyle Charles P · Webster, MNBuilt 2008 · S/N 1075-2008 N989WBCp Aviation Inc · Santa Paula, CABuilt 2012 · S/N 1120-2012 N98ABooe Kent W · Clay City, INBuilt 1973 · S/N 64-73 N990GGoebel Greg D · Petaluma, CABuilt 2002 · S/N 893-2002 N991BCHusby Jeffrey L · Eau Claire, WIBuilt 2024 · S/N 1215-2024 N994TAmerican Champion Aircraft Corp · Rochester, WIBuilt 2026 · S/N 1235-2026 N995WMHangar 7 Aviation LLC · N Redngtn Bch, FLBuilt 1999 · S/N 845-99 N999SPMcgilvray Andrea · Bandera, TXBuilt 1978 · S/N 452-78 N99GKInverted Holdings LLC · Newman, GABuilt 2023 · S/N 1207-2023 N9BYAh C Aviation LLC · Siloam Springs, ARBuilt 2004 · S/N 960-2004

Back to AD 90-15-15 R1