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.
N9968VCynthiana Flying Group Corp · Cynthiana, KYN9968XEagley Ronald A · Anchorage, AKN99697Sky High Leasing Services LLC · Lakeland, FLN9969ARegistration Pending · Frostproof, FLRegistration pendingN9969BGreenwalt Bert · Jonesboro, ARN9969CAttitude Indicators LLC · Allegan, MIN9969THatch Industries LLC · Snowflake, AZN9969VCosta William · Farmington Hills, MIN996AKSierra Sky Aviation LLC · Kalispell, MTN996MWWiehl In The Sky LLC · Mount Juliet, TNN99700Lee Rich · Carlsbad, CAN99709Long Island Aviators LLC · Seaford, NYN9970AKingsley Kiman J · Miller, MON9970VSpalding Flying Club LLC · Griffin, GAN9970ZHartland Aviation LLC · Hartland, MIN99712Nesher Aviation II LLC · Jacksonville, FLN99715N99715 LLC · Wheeling, ILN9971AZilinsky Robert F · Willowbrook, ILN9971EGuerrero-Reyes Fernando G · Princeton, NJN9971NCranford Billy J · Wasilla, AKN9971TGuardalabene Anthony E · Lake Havasu City, AZN9971VWalters Aaron R · Estes Park, CON99725Holladay Aviation LLC · Jacksonville, FLN9972ARegistration Pending · Seattle, WARegistration pendingN9972NChandler E H Jr · Ozona, TXN9972VMotley Charlotte J · Summerdale, ALN9973AGuillebeau Instruction Inc · Sherwood, ARN9973BMajor Air LLC · Charleston, SCN9973FMayer Larry A · Billings, MTN99744Christiansen Aviation LLC · Wilmington, DEN9974BAppalachian Aviation LLC · Harrisonburg, VAN9974ERajdl Alan · Deer River, MNN9974MAllmen David B · Valley Center, CAN99750Kool Wings Leasing LLC · Indianapolis, INN99759Civil Air Patrol · Maxwell Afb, ALN9975TLancello Dylan E · Townsend, MTN99765Tactical Intergriated Training Solutions LLC · Colorado Springs, CON9976AWestern Air Express LLC · Helena, ALN9976BArend Robert E Jr DBA · Mark Center, OHN9976GAbernethy Joe H · Hickory, NCN9976MBrush Wesley A · Sparks, NVN99770Civil Air Patrol · Maxwell Afb, ALN9977AMielke Frederick J III · Plains, MTN9977EDunlap Cameron · Campbell, NYN9977JBoening Bros Dusting & Spraying Inc · Floresville, TXN9977TGastineau Patrick S · Bothell, WAN9977VLunceford James A · Stanchfield, MNN99783Alexander Todd · Westhampton, MAN9978BReal Brian M · Anchorage, AKN9978ELagasse Robert · Wolcott, CT
Back to AD 87-20-03 R2