AD 90-02-13
Registered aircraft · 3,863
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:90-02-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:90-02-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:90-02-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:90-02-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.
N2270FAlbair William R · Hampden, MEN2272FGear Down Hangar LLC · Phoenix, AZN2274FElliott Areospace LLC · Kalispell, MTN2277FEagle Mission LLC · Keystone Heights, FLN2281FClassic Air Aviation LLC · Mesa, AZN2282FSjoblom Donald W · Maple Grove, MNN228JHBuzzed Landing LLC · Ocean Springs, MSN228RDShrader J B · Yuma, AZN2293FTwo Mile High Mining LLC · Victor, CON2296FAttitude Aviators Inc · North Myrtle Beach, SCN2298FTarheel Aviation LLC · Cherryville, NCN22ECDoose Christopher A · Memphis, TNN22HBHubele Conrad · Tucson, AZN22NRJefferson Aviation LLC · Seville, OHN22PTGuy Transportation Ltd · Wilmington, DEN22SBRamsey Timothy · Saraland, ALN230MWGot Wings LLC · Woodbury, NYN231JPQuest Air Inc · Cocoa, FLN232DTChancellor Shares LLC · Liberal, KSN232RSWright Aviation LLC · Lawton, OKN233JHAircraft Holding Solutions LLC Trustee · Newark, DEN2345AAeolus Gold LLC · Wilmington, DEN2349SAjs Aviation LLC · Warroad, MNN234DADestination Management LLC · Tulsa, OKN234DWN234dw Aviation Inc · Okemos, MIN234MSVertical Horizon Aviation LLC · Sandown, NHN234MWKuehn Kevin C · De Pere, WIN234PSTkn Holdings LLC · Pima, AZN234TLLanflisi Robert A · Fairfield, CAN236ATN236at LLC · Miami, FLN236STOutdoor Metal Products LLC · Leighton, ALN237DWTheis Industrial Leasing Inc · Spivey, KSN237SMWestern Rivers Aircraft LLC · Paducah, KYN238FALetourmeau University · Longview, TXN239ELDingman Marine LLC · Orlando, FLN239SERiley Charles Sweeney · Highlands Ranch, CON23DTAlastrom Aviation LLC · Wilmington, DEN23GLAtlantic Assets Holding LLC · Dover, DEN23JDraco Flight School Inc · Chino, CAN23PFBagge Tom · Monticello, IAN23RHCajun Crimson Air LLC · Hoover, ALN23RLCaljet Inc · Van Nuys, CAN240GBSchumaker Joseph W Jr · Petersburg, MIN240RATop Aircraft Leasing LLC · Wilmington, DEN240RCIntegrity Sales And Auction LLC · Merrill, WIN240RTAviation Trust Company LLC Trustee · Oklahoma City, OKN241AJAircraft & Aviation Professionals LLC · Coldwater, MIN241AREllison Aviation LLC · Conroe, TXN241EWFort Carlos LLC · Fort Worth, TXN241MWAircraft Guaranty Corp Trustee · Oklahoma City, OK
Back to AD 90-02-13