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.
N180TPLayson Aviation LLC · Spring Lake, MIN180TRMccann Michael P · Ocala, FLN180TW180 Tw LLC · Rexburg, IDN180UBS T O L LLC · Eagle, IDN180UFBrown Bryan L · Greenwood, ARN180VTrigger Gap Aviation LLC · Kalispell, MTN180VTJlng Air LLC · Scottsdale, AZN180VWTwo LLC · South Paris, MEN180WStein Anthony J · Locust Grove, GAN180WAHelland Gregory A · Wayzata, MNN180WBSchroder Robert D · Buckeye, AZN180WDRegistered aircraftN180WFPowell William A · Falkville, ALN180WGGray Howard W Jr · Grand Prairie, TXN180WHKaltenbach Kevin W · Stanwood, WAN180WJPlane Fun Inc Tr Trustee · Snellville, GAN180WLMerker Christopher R · Lewistown, MTN180WSBiloff Neil L · Milton Freewater, ORN180WWMyers Dale C · King Salmon, AKN180WYTorgerson Co LLC · Almena, WIN180XHigh Desert Land LLC · Rexburg, IDFirst renewal noticeN180XBChandler Christian J · Ashfield, MAN180XPAnders Jack H · Bend, ORN180XRBank Of Utah Trustee · Salt Lake City, UTN180XZGengenbach Joseph G · Livingston, TXN180YKnudson Aviation LLC · Bozeman, MTN180YHRobb Jon D · Alma, MIN180YPCrow Jack R · Bethel, AKN180YSMontgomery Jeffrey · Lone Pine, CAN180YYHastings Jamie · Vancouver, WAN180ZHenderson Ag Service Inc · Osceola, ARN180ZRLundell Don C · Los Altos, CAN18100Liberty University School Of Aeronautics · Lynchburg, VAN18104Toth Stephen K · Northampton, PAN18109Szoke Elliott · Mukilteo, WAN1810RMcdaniel Benjamin G III · Birmingham, ALN1810YLussier Lisa · Greene, RIFirst renewal noticeN1810ZRanzway Corp · Seattle, WAN18110Radke Steven H · Hastings, MNN18115Hinds Community College · Raymond, MSN18118Bokman Charles J III · Athol, IDN1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKN18126Harroun Charles G · Maryville, MON18129Loftics LLC · Kennewick, WAN1812QLiv2fly LLC · Grand Junction, CON1812RDriskell James P · Anchorage, AKN1812XDavid Glen E · Ash Fork, AZN1812YHopkins Mark W · Emporia, KSN18140Johnroe Ryan M · Mount Pleasant, MIN18144Kachemak Bay Flying Service · Temple, TX
Back to AD 97-01-13