AD 2021-23-13
Registered aircraft · 11,300
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:2021-23-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:2021-23-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:2021-23-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:2021-23-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.
N102AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN102AFMjm Enterprises LLC · Wilmington, DEN102AJBird Dog Aircraft LLC · Billings, MTN102BBNester Randal K · Seguin, TXN102BFBell Textron Inc · Fort Worth, TXN102CGSale Reported · Surprise, AZSale reported, pending cancellationN102CQChatham County · Savannah, GAN102CVPilot In Command LLC · Parker, CON102LUBlueskykai LLC · Wilmington, DEN102NJUsda Forest Service Fepp · Trenton, NJN102SHScotts Helicopter Services Inc · Le Sueur, MNN102SUSignature Property Holdings LLC · Wilmington, DEN102SWGeorgia Helicopter Leasing Corp · Douglasville, GAN102UMTimberland Helicopters Inc · Ashland, ORN102WPGarcia Randy S · Montebello, CAN10375Tactical Turtle LLC · Ortanna, PAN1038NSome Beech LLC · Bolivar, MON103AEAir Evac Ems Inc · O Fallon, MON103CGCity Of Burbank · Burbank, CAN103HXHelicopter Express LLC · Chamblee, GAN103JAJoann Air Inc · Mulberry, FLFirst renewal noticeN103JPCity Of Jacksonville Sheriffs Office · Jacksonville, FLN103MTMed Trans Corp · Denton, TXN103NJUsda Forest Service Fepp · Trenton, NJN103VUAir Methods LLC · Greenwood Village, CON1042CRmi Air LLC · Ocilla, GAN1043TCroman Corp · White City, ORN1048PAviation Solution Experts LLC · St Marys, IAN1048YCroman Corp · White City, ORN104AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN104AHAirbus Helicopters Inc · Grand Prairie, TXN104APRock Creek Leasing LLC · Sapulpa, OKN104EGSpitzer Helicopter LLC · Wilmington, DEN104HHHaddock Flying Service Inc · Salters, SCN104LNPathfinder Leasing LLC · Anchorage, AKN104RLVertical Vegetation Management LLC · Darlington, INN104RTBack Nine Aerial LLC · New Berlin, WIN104SUSignature Property Holdings LLC · Wilmington, DEN104TEN104te LLC · Tucumcari, NMN104TVFdfah LLC · Chula Vista, CAN105ACAgricultural Air Services LLC · Jupiter, FLN105AMAir Methods LLC · Greenwood Village, CON105APBearing Tree Land Surveying LLC · Oklahoma City, OKN105ATQualitair LLC · MichelstadtN105CMLewis Donn C · Millington, MIN105GKBank Of Utah Trustee · Salt Lake City, UTN105JDHavens Aviation LLC · Blacklick, OHN105KYRobinson Helicopter Co · Torrance, CAN105LHHelilease LLC · Lewes, DEN105LPEnright Arne P Trustee · Ward Cove, AK
Back to AD 2021-23-13