AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N739TRJeff Air Pilot Services LLC · Shelbyville, INN739TSArispe Aviation LLC · Mckinney, TXN739TTTongass Flyers LLC · Ward Cove, AKN739TUSofla Sky Solutions LLC · Deerfield Beach, FLN739TWAviolease LLC · Vancouver, WAN739UAPea-Wayman Flight LLC · Daytona Beach, FLN739UBFlying H LLC · Lake Placid, FLN739UFMichiana Air Activities Inc · Osceola, INN739UKCarmel Aviation Inc · Boise, IDN739ULAlameda Aero Club · Alameda, CAN739UMSpartan National Holdings LLC · Missoula, MTN739UNFly White Cloud LLC · Lake Havasu City, AZN739UPMelbourne Flight Training LLC · Melbourne, FLN739UQN739uq Associates LLC · El Paso, TXN739VERedstone Arsenal Flying Activity · Redstone Arsenal, ALN739VGHopper Oil Co Inc · Winfield, KSN739VND & L Innovations LLC · Hendersonville, TNN739VPPaviglianiti Oscar · Durango, CON739VRMid-Atlantic Air Ventures Inc · Richmond, VAN739VSNicol Alan F · Spokane, WAN739VTChambers Todd R · Brundidge, ALN739VVRosev Simeon B · Albuquerque, NMN739WAChew Stephen Yk · Honolulu, HIN739WBHall Andrew B · Anchorage, AKN739WFSkywarrior Flight Training LLC · Pensacola, FLN739WHHay Greg L · Conway, ARN739WKCooper Co LLC · Tomahawk, WIN739WLDorton Aviation LLC · Lebanon, VAN739WMSundance Aviation Inc · Richland, WAN739WRRaritan Valley Flying School · Princeton, NJN739WXAce Of Spades Aviation LLC · Las Vegas, NVN739WYN739wy LLC · Cheyenne, WYN739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeN739XA7550g LLC · Birmingham, MIN739XCAllen Danny T · Jonesboro, LAN739XKAirways Aviation Inc · Grand Rapids, MNN739XLFlyrjf LLC · Weirsdale, FLN739XMEnstad Ordell J · Goldendale, WAN739XSGorman Patrick M · Deerfield, OHN739XTS O W Aviation LLC · Crystal River, FLN739XUTraining Mission Aviation Inc · New Tripoli, PAN739XVAmaro Mark S · Mi Wuk Village, CAN739XWWhole Life Wellness Center · Alpine, TXN739YESundance Air Services Inc · Alameda, CAN739YHMelbourne Flight Training LLC · Melbourne, FLN739YMHeritage Aviation LLC · Ankeny, IAN739YRF&O Flight LLC · Calhoun, GAN739YURrrr Aviation LLC · Bryan, TXN739YWPettit Toby B · Morehead, KYN739YZSocal Aviation Inc · Chino, CA
Back to AD 79-10-14 R1