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.
N1871MHickam James R · Dayton, WAN1871QHemstad Christopher L · Portland, ORN1871VMcpherson Philip D · Battle Creek, MIN1871XEveland Scott B · Waukesha, WIN18720Bailey Bryan M · New Waverly, TXN18723Simpkins Larry D · Williamson, WVN18724Friedlin Jason B · Hallieford, VAN18725Ayers Francis H Jr · Palm Coast, FLN1872MRenforth Michael · Yorktown, VAN1872QQualitair LLC Trustee · MichelstadtN1872XHogsett Steve R · Barboursville, WVN1872YKamp Implement Co · Belgrade, MTN18731Rotormate LLC · Royse City, TXN18733Hall Thomas R · Ford City, PAN18737Giamichael Thomas C · Hudson, NYN18738Cardinal Flyers Inc · Northborough, MAN18739Monaco Michael · New Windsor, NYFirst renewal noticeN1873MAsmus Edward W III · Sugar Grove, ILN1873YTullier Mary A · Talihina, OKN18745Andrews Clark N · San Diego, CAN1874YCouncil Melvin · Squaw Valley, CAN1874ZSiggard Kurtis K · Sacramento, CAN1875FMcfadin T E · San Antonio, TXFirst renewal noticeN1875YBrotheridge Bryan R · Merritt Island, FLN1876MTracy Peter E · Bishop, CAN1876QShuford Lon R · Cumming, GAN1876VRedding Aero Enterprises Inc · Redding, CAN1876XCrow Bill D · Yorba Linda, CAN1876ZHzl Hanger LLC · Drums, PAN1877FHoots Kent B · Macon, GAN1877XOrehotsky David W · Dallas, PAN1878MUS Sander LLC · Esperance, NYN1878QKachemak Bay Flying Service Inc · Temple, TXN1878ZRpm Diesel LLC · Grants Pass, ORN1879ERaw Racing Inc · Puyallup, WAN1879FKris Noone Air LLC · Wilmington, DEN1879ZQuad City Skydiving Center Inc · Coal Valley, ILN187BCCounty Of Butte · Oroville, CAN187ERMustang Sally Aviation LLC · Camden, SCN187GCZuni LLC · Kirkland, WAN187HATexas Stick And Rudder LLC · Cleveland, TXN187MADoyle Dennis J · Livermore, CAN187MBBaker Aviation Consulting LLC · Summerland Key, FLN187MMSelf Aviation LLC · Hayden, IDN187WWOsprey Aviation LLC · Riva, MDN1880MPalm Hammock II LLC · Zolfo Springs, FLN1880QNewby Patrick · Mentor, OHN1880VKdn Aviation LLC · Annapolis, MDN1880XKarod John W · Union, MEN1881MBrutlag Farms Inc · Wendell, MN
Back to AD 97-01-13