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.
N9012HLeading Edge Flight Academy LLC · Bend, ORN9012MMutchler Joseph T · Billings, MTN9012XGone Flying LLC · Bartlesville, OKN9013CMarch David H · Lincoln, CAN9013TLamb Aaron C · Vail, AZN9013XSpooner Brian P · Poway, CAN9014HFlex Air Holdings Inc · Manhattan, KSN9014MAvery John W · Fergus Falls, MNN9014XSudoh Kenji · Duluth, MNN9016CLindblom Carl O · Saxon, WIN9016GSkydive Duluth Superior LLC · Superior, WIN9016MKinslow Aviation LLC · Prague, OKN9016TDiaz Mark Adba · Madera, CAN9016XWolfe John G · Tooele, UTN9017HMeece Harvey T · Somerset, KYN9017TCombs Ryan W · Carson City, NVN9018AGodbold Robert L · Apex, NCN9018GSimpkins Lynn DBA · Costa Mesa, CAN9018MMclain Daniel E · Baden, PAN90193Renfro Michael W · Bethel, AKN9019CHanks Don N · Eagle River, AKN9019XJudah LLC · Springdale, ARN901JWings Over Texas Holdings LLC · Denton, TXN901JGWestland Aviation LLC · Lake Havasu City, AZN901JMGuderjahn Raymond · Garden Plain, KSN901KSMbk Leasing And Consulting LLC · Lakeland, FLN901LJPegasus Flight Resources LLC · Charlotte, VTN901MPMccole Kevin · Brookline, NHN901PWFlywerx LLC · Anchor Point, AKN901RJMiller James A · Granada Hills, CAN901SWWilson Paul C · Jefferson, GAN901TGWestland Aviation LLC · Lake Havasu City, AZN901UBowling Robert E · Argillite, KYN9020GAmeritek LLC · Tuttle, OKN9020XBrackett Clayton J · Coopersville, MIN9021GRector Edward L · Nederland, TXN9022CBarber Theodore C Trustee · Spanish Fork, UTN9022MDaytona Beach Aero Club Inc · Ormond Beach, FLN9022THale O'Lele Corp · Honolulu, HIN9022XPartner 91 LLC · Scottsdale, AZN9023CAinsworth Warren B · Vestavia Hills, ALN9023GBull Bren C · Kingsville, TXN9023TBauer John P · Medford, WIN9023XBlue Skies Matter LLC · Spokane, WAN9024AHarbick Joshua W · Bend, ORN9024CBaker Lewis E Jr Trustee · Anchorage, AKN9024GJessop Jacob N · Cedar City, UTN9024MDamianov Venko · Dallas, TXN90252Weigman Michael S · Altamonte Springs, FLN9025GN9025g LLC · Indianapolis, IN
Back to AD 87-20-03 R2