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.
N1931VRegistered aircraftN1931XRuffner Ryon Garrett · Argyle, TXN1931ZCrandell Cyrus · Rockville, INN19320Hynes Timothy M · Pepperell, MAN19323Novinski Gerald W · Jacksonville, FLN19325Leon River Aerial Services LLC · Dublin, TXN19326Sagen Josh H · Kalispell, MTN19328Amesbury Robert S · Davis, CAN19329Harvey James · Arlington, TNN1932QHogan James C DBA · Cameron Park, CAN1932UFryer Charles Trustee · Glendale, AZN19333Northwest Wings LLC · Hillsboro, ORN19334Beiswinger Matthew · Republic, MON19336Ozark Aviation Services LLC · Wasola, MON1933FVidal Aviation LLC · Gaithersburg, MDN1933MShepherd Matthew R · Bloomington, INN1933XHall Michael D · Athens, ALN1933ZIsherwood Robert N · Carnesville, GAN19342Wojciechowski Calvin · Sonoma, CAN19343Goheen Gordon C · Battle Ground, WAN19345Dynan Erik J · Whitefield, NHN19346Acevedo Adriel · San Antonio, TXN1934MKornetzke Jeffrey A · Lake Mills, WIN1934XMarshall Michael R · Collierville, TNN1934ZKlausen Mark R · Overland Park, KSN19351Place Joseph E · Springville, NYN19355Airco Interational LLC · Arlington, WAN19358Browning Helen · Peoria, ILN1935ZHubbert Leroy N · Mecosta, MIN19364Ja Flight Services LLC · Sugar Grove, ILN19367Boyer Timothy J · York, PAN1936FCheek David H · Garland, TXN1936MScott George M · Reno, NVN1936XNelson William T · Benton, KYN19370Clanton Ronald W · Aurora, CON19374Wilson Aviation Consulting LLC · Willis, TXN19377Caffroy Daniel R · Anchorage, AKN1937FA2 Flight Leasing LLC · Castro Valley, CAN1937MPoultry Not Beef LLC · Chancellor, ALN1937XOrtiz Marquez Ricardo A · Melbourne, FLN19380Fannin William A II · Lexington, KYN19384Armstrong Thomas J · Ann Arbor, MIN19387Debo Group Inc · Uniontown, OHN19388Kittner Robert T · Ellenville, NYN19389Clenow Mark · Brighton, MAN1938ZSuffern Glenn · Shady Shores, TXN1939QGustafson Keith W · Waleska, GAN1939X1939xray LLC · Chester, SCN1939ZBrooks James R · Oak Grove, MON193DC310 Charter LLC · Zanesville, OH
Back to AD 97-01-13