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.
N9638VCrazy Aces LLC · St George, UTN9638XPiper Earl Holdings LLC · Newark, DEN96393Graham Eric H · Johnson City, TXN9639XFerguson John · Montrose, CON963AYStark Truss Co Inc · Canton, OHN963KMMiller Karl E Trustee · Chandler, AZN963MSMount San Antonio College · Walnut, CAN963WAChase Kenneth C Jr · Rochester, MNN963WMMorrison William S · Aliquippa, PAN96403Skylens LLC · Hammond, LAN9640BHanson Glen W · Anchorage, AKN9640HCorriher Mark B · Mocksville, NCN9640QFour Zero Quebec Inc · Cheyenne, WYN9640TJohnson Joshua S · Lake Jackson, TXN9640VN9640v LLC · Ann Arbor, MIN96410Penny John C Jr · Sterling, CON96411Zz Top Rentals Inc · Missoula, MTN96416Wolstenholme Ralph E · Westfield, PAN96418Twin City Cloud 7 Inc · Eden Prairie, MNN96419Thompson Steven · Rockwall, TXN9641BFlying Brown Dog LLC · Boulder, CON9641HBarton Alva L · Hollister, CAN9641QBhairavi Aviation LLC · Santa Clarita, CAN9641VRink Douglas B · Woolwich, MEN9641ZWhitehead Michelle W · Centralia, WAN9642TDavidow Clifford A · Portland, ORN9643HMor Aviation N9643h LLC · Gaithersburg, MDN9643QLeading Edge Flight Academy LLC · Bend, ORN9643TDunn Meghan Elizabeth · Mckinney, TXN9643VBrazos Valley Flight Services LLC · College Station, TXN9643ZAdams Aviation Services Inc Trustee · Wilmington, DEN9644GKatmai Air LLC · Anchorage, AKN9644QSkyhawks Inc · Chippewa Falls, WIN9644TFloyd Andrew W · Mesa, AZN96455Haeussler Arne · Chandler, AZN9645GConnolly Michael T · Ferndale, WAN9645HSantiago Diana L · Juana Diaz, PRN9645VOak Ridge Flyers Inc · Oak Ridge, TNN9645XCall The Ball Aviation LLC · Phoenix, AZN96462Skylens LLC · Hammond, LAN9646BN9646b LLC · Wilmington, DEN9646XKomko Randy M · Mckenna, WAN96474Skylane 4 LLC · Leesburg, FLN96475Gregg Flying Service Inc · Durango, CON96476After Global Holdings Corp · Wichita, KSN9647BLakewood Investments LLC · Victorville, CAN9647QKaeni Law Group Inc · Santa Ana, CAN96480Mfkc182 LLC · Lantana, TXN9648HSaunders Larry F · Sulphur Springs, ARN9648QGreen Bay Flying Club Inc · Krakow, WI
Back to AD 87-20-03 R2