AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N8942BBishops Sky Cam LLC · Jonesburg, MON8942GSale Reported · Stevensville, MTSale reported, canceledN8942TMonger Curtis V · Bend, ORN8942VPilots Flying School LLC · Englishtown, NJN8942XBlb Group LLC · Lake Havasu City, AZN89430Flabob Airport LLC · Jurupa Valley, CAN89433Chapel Hill Flying Club Inc · Sanford, NCN89438Sun Aircraft Management LLC · Ormond Beach, FLN8943BHarris David B III · Parlier, CAN8943GTruyaert Ivan R Jr · New Carlisle, INN8943VZiegler Aviation LLC · Minneapolis, MNN8944GSagra Nw LLC · Ronan, MTN89456Czyzewski Justin · East Brunswick, NJN8945TLumpkin Ed · Rosie, ARN8945XHarty Arthur · Acampo, CAN89464Freeway Airport Inc · Mitchellville, MDN89469Hershberger David A · Unionville, INN8946BLumberjack LLC · Flagstaff, AZN8946VWings Over Texas Holdings LLC · Denton, TXN8946XKennedy Dennis R Trustee · Westlake Village, CAN8947BKaczmarek Richard G · Sandersville, GAN8947SMatyas Aviation Inc · Sugarloaf, PAN8947VMills Alan F · Chatom, ALN8947XN8947x LLC · Middletown, DEN8948GWilbur-Ellis Co · Salinas, CAN8948VPlain Company Ltd · Bloomfield Hills, MIN8948XRhodes Steven D · Anchorage, AKN8949GChuckanut Flying Club Inc · Bellingham, WAN894AHAerospace Asset Holdings LLC · Wilmington, DEN89503Menne Aviation LLC · Brooklyn Park, MNN8950BPeppers Denise S · Centre, ALN8950TGribi Daniel M · Miranda, CAN8950XAnderson Craig M · Barron, WIN8951GThrash Helen · Pelahatchie, MSN8952TNorthwest Exteriors Inc · Rancho Cordova, CAN89531Glynco Manning Aviation Inc · Brunswick, GAN89533Ashby Shawn Alan · San Luis Obispo, CAN89539Jkg LLC · Murfreesboro, TNN8953GAirfleet Solutions LLC · Newark, DEN8953TDouglass Jason E · Friday Harbor, WAN8953XHenning Jeffrey Carl · Prescott, AZN89549Jodkin Jason J · Confluence, PAFirst renewal noticeN8954URausch John H · Fairport, NYN8954XGansz Kenneth L · Clare, IAN8955SHewett Donnie · Little River, SCN8955XPampa Office Supply · Elk City, OKN8956TBrown Donald L · Peoria, AZN8956XLove Brandon · Big Sandy, TXN8957BScott Larry R · Hobbs, NMN8957SMiller Andy · Marana, AZ
Back to AD 87-20-03 R2