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.
N9813BTsiper Evgueni · Eagan, MNN9813ER&L Enterprise Group LLC · Wilmington, DEN9813HDowney Corp · Cornwall, VTN9813LCivil Air Patrol Inc · Maxwell Afb, ALN9813THenley Enterprises Inc · Mangonia Park, FLN9813VArf Corporation · Brooklyn, NYN9814GNoble Jeremy · Stanwood, WAN9814TWickizer Stephen W · Knoxville, TNN9815AReese Steven A · Shoreline, WAN9815GKenmore Air Harbor LLC · Kenmore, WAN9815HAnderson Joseph Richard · Lewiston, IDN9815LWestosha Flying Club Inc · Kenosha, WIN9815ZSilver Creek Aviation Services · Fort Worth, TXN9816EArizona Air Salvage · Phoenix, AZN9816GRicker Harry K · Turner, MEN9817GLester Matthew J · Gouldsboro, MEN9817HBurcham Timothy Scott · Encinitas, CAN9817JDonahue Patrick J · Carriere, MSN98182Bena Christopher D Trustee · Wasilla, AKN98186Loyer Jeffrey W · Olympia, WAN98188Usda Forest Service Fepp · Columbia, SCN98189Kashmere Apartments LLC · Missouri City, TXN9818GGough Gregory · Emmett, IDN9818HFowler Raymond E · Smyrna, GAN9818XPlath James F · Davenport, NDN9819HStanley Aero Club Gastonia Inc · Belmont, NCN9819JFranco Louise A · El Cerrito, CAN981AKState Of Alaska · Anchorage, AKN981MARed Rose Flight Tours LLC · Lancaster, PAN981RDSunrise Adventures LLC · Stillwater, MNN981SCCarter Brooks LLC · Kalispell, MTN981WBFlying Fortress Of Swfl LLC · Fort Myers, FLN981WMFlying Fortress Of Swfl LLC · Fort Myers, FLN98207Perkins Robert T · Anchorage, AKN9820HSeghieri Richard T · Santa Rosa, CAN9820JBenair LLC · Bonita Springs, FLN9820TSamson Robert C · Waterford, WIN98219White Jeffrey M · Carlsbad, CAN9821CN5965t LLC · Lehigh Acres, FLFirst renewal noticeN9821ERegistered aircraftN9821GGrubelich Mark C · Edgewood, NMN9821HDowning Darrell W · Drakesville, IAN9822ESample John A · Gonzales, TXN9822HPetsche Tim E · Meridian, IDN9822JSiskiyou Pacific Inc · Central Point, ORN9822VJohnson Mark W · Valrico, FLN9822XHultquist Daniel D · Anchorage, AKN9823ADuke Kay L · Darrouzett, TXN9823LSilverhawk Aviation Academy LLC · Caldwell, IDN9823VSundance Aviation Inc · Moriarty, NM
Back to AD 87-20-03 R2