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.
N33ATKrebs Bernd R · Sandwich, ILN33BBHendricks Timothy J · Telluride, CON33CDElliott Kathy · South Thomaston, MEN33DBBowers Albert Joseph Jr · Aberdeen, MDN33DMGray Chad T · Garden Valley, IDN33DPB&C Cejka Real Estate LLC · Sioux City, IAN33EEDes Moines Skydivers LLC · Des Moines, IAN33FCReece Trucking And Excavating Inc · Marysville, WAN33GCMarble Jere D · Dayton, NVN33GJOliser Andras · Savannah, GAN33GSFish N Fly LLC · Hobe Sound, FLN33HLKnudsen Russell G · East Troy, WIN33JHRoelfs Vernon L · Eagle River, AKFirst renewal noticeN33KRAviaschin LLC · Frisco, TXN33KYBurnette Ric A · Sebastian, FLN33LDLeahey Thomas C · Huntington Beach, CAN33LFJbo Airventures LLC · Saint Petersburg, FLN33LJUniversal Aviators Academy Inc · El Monte, CAN33MGTopeka Flyers Inc · Topeka, KSN33MHAkeyson Edward W · Durham, CTN33MLDaedalean Inc · Chandler, AZN33NHIsr Platforms LLC · Tysons, VAN33NRLuis Antonio · Miami Springs, FLN33REChapman Richard B · Granbury, TXN33RNMurphey John L · Fredericksburg, VAN33SQJohnston H Kenneth II · Wheatland, WYN33TSDevco Properties IV LLC · Louisville, KYN33UWPadf LLC · Fort Collins, CON33VERotermund Brett L · Fairbanks, AKN33VGTexter Mountain LLC · Reinholds, PAN33VTTjr Aviation LLC · Orefield, PAN33WNClover Crest II Inc · Key Largo, FLN33WVInarayan Inc · Winter Park, FLN33YPFlight Control Services Of Florida Inc · Milton, FLN34005Hinckley David D · Belton, TXFirst renewal noticeN3400FSpencer Aviation Services LLC · Sanger, TXN3400VLanier Gary L · Bloomington, ILN34011Cross Charles W Jr · Willoughby, OHN34012Cap Flyers Aero Club LLC · Ocala, FLN34014Rupp Gregory J · Deltona, FLN34015Leftwich Brian · Savannah, GAN34019Kortum Ronald L · Williamstown, NJN3401SSonntag Robert Dennis · Volant, PAN34029Rigdon William K · Hazel Green, WIN3402FTran Dzung V · Las Vegas, NVN3402RBurton Darrell · Somerset, KYN34030Sommer Greg J · Maryville, ILN34038B&B Cardinal LLC · Alexandria, VAN34039Snedeker Andrew · Jackson, NJN3403ULintvedt Brian · Presho, SD
Back to AD 97-01-13