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.
N9539BThree Rivers Limousine Service Inc · Pittsburgh, PAN9539HNorthwest Flyers Inc · Marianna, FLN953ASA2g International LLC · San Juan Capo, CAN953CCScruggs Ken · Plain City, OHN953HAEkstrom Benjamin G · Anchorage, AKN953SASunrise Aviation Inc · Ormond Beach, FLN953SMBogen Alfred T · Brandon, MSN953STBoone Keith · Cabot, ARN95404Delta State University · Cleveland, MSN9540AAlder George A · Palmer, AKN9540BFly8ma LLC · Big Lake, AKN9540GSchwend Brian · Forsyth, MTN9540LCivil Air Patrol Inc · Maxwell Afb, ALN9540TChino Aviation Inc · Chino, CAN9540XWhitetop Air LLC · Wilmington, DEN9541BBodick John K · Anchorage, AKN9541GAllen Charles Mark · Puryear, TNN9541TNevill John D · Tahoka, TXN95429Suburban Air Corp · Castro Valley, CAN9542BSoileau Kenneth B · Lancaster, SCN9542HAbusham Hamed M · Upland, CAN9542TLarsen Richard A · Wannaska, MNN95431Kent State University · Stow, OHN95435Bird Acquisition LLC · Phoenix, AZFirst renewal noticeN9543ABest Alvin A · Anchorage, AKRegistration revokedN9543HGonzalez-Rio Jesus A · Big Pine Key, FLN9543XBarth Samuel · Fonda, NYN95444Kent State University · Stow, OHN95445Kent State University · Stow, OHN9544ADaugherty Lee H · Charleston, WVRegistration revokedN9544HSouthern Aero LLC · Homestead, FLN9544XB&B Aviation LLC · Arlington, WAN9545AJetl Aviation LLC · Southern Pines, NCN9545BSunrise Aero Inc · Ocala, FLN9545XRichardson Dana C · Okeechobee, FLN95469Kent State University · Stow, OHN9546AStevens Scott D · Corsicana, TXN9546GSale Reported · Emerson, IASale reported, canceledN9546HMiller Dale L · Bozeman, MTN9546TAerographics Inc · St Cloud, MNN9546XN9546x LLC · Lakeville, MNN95474Kent State University · Stow, OHN95475Kent State University · Stow, OHN9547AChristiansen Brent D · Mabton, WAN9547LCivil Air Patrol · Maxwell Afb, ALN9547XCundiff Zackery A · Klamath Falls, ORN9548GMeyer Bros Ag LLC · Algona, IAN9548XMclenaghan Alvin · Phoenix, AZN95494Valiair Limited Co Trustee · Casper, WYN9549GMacica Stephen J DBA · Truckee, CA
Back to AD 87-20-03 R2