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.
N1881YSutton Aircraft Salvage LLC · Palmer, AKN1882XWagner Robert W · Casper, WYN1882YDunlap Alexander W · Eads, TNN1882ZConstable William H · Rch Palos Vrd, CAN1883FAnkeney Scott · Canyon, TXN1883QMitchell Philip J · Arlington, TXN1884VMurphy Edward L · Fairmont, WVN1884XKaines John L · Ludington, MIN1885MLittle Dog Aviation LLC · Anchorage, AKN1885QHansen Peter J · New Iberia, LAN1886VAngelone Inc · Elkhart, INN1887FHeadings Kevin · Echo, ORN1887QLosyad LLC · Sanford, FLN1887ZDavidson David R · Sutton, AKN1888QAmerican Aerial Photos LLC · Efland, NCN1889FPiper Henry Burton Jr · Kingston, TNN1889QRuff Randall N · Bay City, MIN1889VCroome James Earl Jr · Sandersville, GAN188DFArc Holdings LLC · Grand Junction, IAN188GCZuni LLC · Kirkland, WAN188GWBrown Die Casting & Manufacturing Inc · Royse City, TXN188HS&T Aviation LLC · Santa Teresa, NMN188HTReady Aim Flyer LLC · New Castle, DEN188PLe Duc Richard Steven · Mazama, WAN188SRRogers Steven Trustee · Ogden, UTN189Jones William Cody · Roxton, TXN1890MPutney Bruce N · Midlothian, TXN1890ZAlaniz Jose M · Yreka, CAN1891MStarkman Timothy S · Monterey, CAN1891YCarolina Sky LLC · Rock Hill, SCN1892FPanagotacos George · Corona, CAN1892VSmith Air Inc · Ukiah, CAN1892XCuvar Philip M · Granite City, ILN1892YBaker David Laurence · Nelson, WIN1893FKleeman Mark · Kearney, MOFirst renewal noticeN1893QSauk Prairie Aviators LLC · Merrimac, WIN1893YWhelan John J · Mount Vision, NYN1894EDelvest LLC · Grosse Pointe, MIN1894XCorso Aviation LLC · Southlake, TXN1894ZEverly Peter · Fort Smith, ARN1896XSmr Holdings LLC · Martinsburg, WVN1896YArmond Richard Joseph · Thousand Oaks, CAN1897QGuadarrama Joe R · Vacaville, CAN1897VBarxbar Aviation LLC · Mesa, AZN1898XScott Ayer Interests LLC · Phoenix, AZN1898ZSmart Robbie A · Wasilla, AKN1899MLoki Adventures LLC · Norwood, CON1899QAlvord Jeffrey C · Tucker, GAN1899SBuon Volo LLC · Queen Creek, AZN1899ZLarlee Coleman R · Millbrook, AL
Back to AD 97-01-13