AD 2000-01-16
Registered aircraft · 2,711
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:2000-01-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16')
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:2000-01-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16') 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.
N20MWStriebel David J · Dayton, OHN20WAOn Air Company LLC · Sewickley, PAN210FCBaked Industries Inc · Yuba City, CAN211SVMatthews Aviation LLC · Greensboro, NCN21234Positive Rate LLC · Kenosha, WIN212RVMinuteman 12 LLC · Wilmington, DEN213MRogers Ronald J · Crystal Lake, ILN214CCSteele Aviation LLC · Tuscaloosa, ALN214DFGaylord Hangars LLC · Gaylord, MIN215CBKw Bradley Associates LLC · Manlius, NYN215MPPersson Timothy J · Kansas City, KSN216LBBail Air LLC · Port Saint Lucie, FLN218CFLevel 200 LLC · Charlottesville, VAN21GFBas Part Sales LLC · Greeley, CON21KDMrd Aviation LLC · Windsor, CON21MTTarrant County College · Fort Worth, TXN21SGTwo One Sierra Golf LLC · Seattle, WAN21SSMidwest Corporate Air Inc · Bellefontaine, OHN21WUDallas Aero & Sales LLC · Poplar, MTN220GDJoseph M De Lecce Trustee · Prather, CAN220XPOleary Patrick G · Lake Tapps, WAN2211QHill Jeffrey A · Bridgeport, WVN2214Q421 Partners · Delphi, INN2221QAviation Sales And Charter LLC · Dover, DEN222AXGraven Timothy G · Foristell, MON222BJFlight Smith LLC · Orem, UTN222FGSkytravel LLC · Victoria, TXN222LTwo Motor Odor LLC · Paris, TXN222MDElx Aviation LLC · Hartford, MIN222PLAnderas Per R · Green Bay, WIN222PRFlying South LLC · Wilmington, DEN222RDAviation Consultants Inc · San Luis Obispo, CAN222RMKelco LLC · Helena, MTN222STEau Claire Aviation LLC · Eau Claire, WIN222SVEllsworth Jason W · Hamilton, MTN2235QSparx Logistics USA Ltd · Charlotte, NCN2236QWoods Leland W · Klamath Falls, ORN223PBHyannis Air Service Inc · Hyannis, MAN226HPRegistration Pending · Valdosta, GARegistration pendingN228JHBuzzed Landing LLC · Ocean Springs, MSN2293FTwo Mile High Mining LLC · Victor, CON22AMJays Aircraft Maintenance Inc · Costa Mesa, CAN22GBHolland Kenneth F Trustee · Santa Clarita, CAN22NRJefferson Aviation LLC · Seville, OHN22PTGuy Transportation Ltd · Wilmington, DEN230MWGot Wings LLC · Woodbury, NYN231JPQuest Air Inc · Cocoa, FLN232ASGuggenair LLC · Carbondale, CON232DTChancellor Shares LLC · Liberal, KSN233JHAircraft Holding Solutions LLC Trustee · Newark, DE
Back to AD 2000-01-16