AD 97-01-13
Registered aircraft · 54,837
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
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N1690RFederal Aerial Applicators LLC · Wilmington, DEN1691CSchrom Edward C · Manchester, PAN1691FVess Joel W · Cherryville, NCN1692CVandevoorde Gary A · Davenport, IAN1692FBeck Seth · Deer Lodge, MTN1692MClark Shawn W · Anchorage, AKN1692YSeaplanes R Fun Inc · Wilmington, DEN1693CDeardorff Dallas · Plains, MTN1693RLeap Aviation Inc · Wilmington, DEN1694EAerobiz LLC · Lewes, DEN1694MWraith Lane T · Wasilla, AKN1694RCrow Rock LLC · Stillwater, MNN1695CSpeed Richard · Boise, IDN1695MGc Profits Inc · Reedley, CAN1695QJostad Leo D · Bottineau, NDFirst renewal noticeN1695RLehne Michael · Portland, ORN1696CCarraher Mark T · Spalding, NEN1696RMoore Alan · Glenwood, ARN1696XCenturion LLC · New Bern, NCN1696YAkinde Oluwatoyin Adenike · Brooklyn Park, MNN1697YKoerner Matthew · Garfield, NJN1698QHudson Gregory K · Deming, NMN1698RRussell Robert Q · Genoa City, WIN1698VStem Aviation Academy · Carlsbad, CAN1698XCmo Blue Sky LLC · Tomball, TXN1699CGrismer Jeff Trustee · Hemet, CAN1699MCodner Nicholas Jr · Londonderry, NHN1699RMacdonald Eric J · Belleville, MIN1699ZSkopec David P · Bend, ORN169AJNolan Davis Dds LLC · Juneau, AKN169AMMargitan Allan R · Nine Mile Falls, WAN169DKStanton James · North Barrington, ILN169DPAdrenaline Inc · Chambersburg, PAN169ECFirst Eclipse Limited · Richmond, VAN169FLBlue Moon Holding Co LLC · Boca Raton, FLN169FTHolmstrom Darrell D Trustee · Anchorage, AKN169HCButterfly Wings Of Miami LLC · Miramar, FLN169JABixby & Sons LLC · Vale, ORN169JMBravo Alpha LLC · Driggs, IDN169JWPatterson Matthew D · Knoxville, TNN169KD182 Flight Corp · Bronx, NYN169KSSvetfur Aviation LLC · Camden, SCN169NMaxfield Douglas · Chico, CAN169NESouth Coast Aviation Inc · North Bend, ORN169PPOrtiz Peter · El Paso, TXN169TFStewart Scott A · Anchorage, AKN169WCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN16AHendrix Aviation LLC · Benton, ARN16AJA&J Air Sales Inc · San Antonio, TXN16ASStefenelli Aviation N Tr Inc Trustee · Attersee
Back to AD 97-01-13