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.
N19700Johnson Dean W · Watertown, SDN19701Old School Aircraft LLC · Jackson, TNN19702Dosair Inc · Slatington, PAN19703Cloud Dancer Aviation Inc · Deland, FLN19706S&S Aircraft Inc · Bennington, VTN19707Wings Over Texas Holdings LLC · Denton, TXN19709Lewis Michael E · Carmel, INN1970FSkymaster Stc LLC · Mena, ARN1970MAirborne Resources Inc · Midlothian, TXN1970XJohnson Christopher S · Portland, ORN19710Bremfour Aviation Group Inc · Wilmington, DEN19711Conetta Gregory J · Kinnelon, NJN19712Humble Lewis N · Grand Blanc, MIN19717Roth Mark E · Stevensville, MTN19719Kejr Melvin P · Salina, KSN1971FButterfly Aviation Inc · Goodland, KSN1971XHigh Country Air Service LLC · Albuquerque, NMN1971ZKrebs Keith C · Fort Worth, TXN19720Gooney Bird LLC · Chandler, AZN19722Autumn Transportation LLC · Nashville, TNN19727Wings Over Texas Holdings LLC · Denton, TXN19729Canale Anthony · Friendswood, TXN1972EMartin George C · Charleston, WVN1972QFlying Associates Inc · Hudson, WIN1972USparrow Thomas E · Hawley, MNN19730Terrasi John D · Pittsfield, PAN19731Valiair Lc Trustee · Casper, WYN19733Jones Darrell W · Kennett, MON19736Friendship Mark · Topanga, CAN19739Breen Peter Herschel · Irvine, CAN1973FRuiz Naile C · Davie, FLN1973JMormile Jason B · Fultonville, NYN1973USilver Fox Aviation LLC · Bay City, MIN1973VMurphy Peter · Streamwood, ILN1973XSuttle Joseph Scott · Moody, ALN1973ZFinnelly Daniel T · Pasco, WAN19740Hendrickson David O · Crab Orchard, KYN19742Four Hearts Farm LLC · Sunbury, OHN19746Kingdom Aviation Group LLC · Thomasville, GAN19747Chase Tyler D · Ephrata, WAN19748Scaringe William A Jr · Culver City, CAN19749Curry Kim M · Griggsville, ILN1974FBusler Bradley R · Nacogdoches, TXN1974JTexarkana Flying Club Inc · Texarkana, TXN1974QMag Air LLC · West Miami, FLN19751Alaska Farm Tours LLC · Palmer, AKN19752Platt Aaron · Heppner, ORN19753Southern Aircraft Consultancy Inc Trustee · Casper, WYN19754Michael J Lefave Cpa Apc · Three Rivers, CAN19757Kalamir Richard · Valparaiso, IN
Back to AD 97-01-13