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.
N177RZCardinal Investigative Alliance Ltd · Chicago, ILN177SDMillner Paul A · Berkeley, CAN177SHAdams Richard D · Kalamazoo, MIN177SKHartwig Lonnie D · Edgeley, NDN177SLSimply Living LLC · Fort Myers, FLFirst renewal noticeN177SMFree State Flying Club Inc · College Park, MDN177SVDlg Aviation LLC · Lena, WIN177TGSerenity Aviation LLC · Oxford, NCN177TJCobb Joseph Jr · Medina, OHN177TKNoblett Ronald D · Bellaire, TXN177TMWheeler Floyd G · Stanton, TXN177TPSavinsky Martin W · Erie, CON177TSAero Cardinalis Inc · Midlothian, TXN177TXTurbine Aircraft Marketing Inc · Lewisville, TXN177UKValiair Lc Trustee · Casper, WYN177VAnglin Robert · Rochester, MNN177VAAerial Specialties Inc · Decatur, TXN177VBBalthis John A · Pleasant Hill, MON177VKKreizinger Natalie · San Diego, CAN177VSBas Part Sales LLC · Greeley, CON177VTSeelig Richard W · Amherst, MAN177WBCardinal 3 Flyers LLC · Springfield, OHN177WFTexoma Redbird LLC · Kingston, OKN177WMFarley Glen · Marysville, OHN177WPForbes William T · Moorhead, MNN177WSSchroeder David B · Centennial, WYN177XCColeman Timothy R · Morgantown, KYN177XPHills Denver L · Show Low, AZN177XSWilson Kent M · Roanoke, VAN1780MCherri Stanley · Pearland, TXN1780QDabone Salim · Dell City, TXN1780RDoellefeld Jason T · Langsville, OHN1781CHenkelmann David H · Janesville, WIN1781RDale Mar Enterprises Inc · Granton, WIN1781VAmbis Edward J · Ithaca, NYN1782FCfi Care Inc · Woodbury, CTN1783MRyan Jason P · San Francisco, CAN1784EHigh Road Time LLC · West Palm Beach, FLN1784FTompkins Wyatt · Pearland, TXN1784MWhitledge Aviation LLC · Princeton, INN1784QRed Cardinal Aviation LLC · Chantilly, VAN1784RCunning Aviation LLC · La Mesa, CAN1785CBorns Frederick G · Chandler, AZN1785FSale Reported · Farragut, TNSale reportedN1786MClark David A · San Jacinto, CAN1786RWhalen Dann Trustee · San Diego, CAN1787CMorris Charles W · Wasilla, AKN1787FSchroder Robert D · Buckeye, AZN1787QHancock Aviation LLC · Baton Rouge, LAN1788QElgamil Noureldin M · West New York, NJ
Back to AD 97-01-13