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.
N9106XCollinsville Design LLC · Newington, CTN91078T Or M LLC · Brentwood, TNN9107BGrace Community Church · Fremont, OHN9107CCagle Holdings LLC · Jenks, OKN9107HChm Aviation LLC · Wilmington, DEN9107MBurns Robert L · Bremen, GAN9107UAnderson Christopher · Janesville, WIN91084Cropair Flying Service Inc · Cody, WYN9108AHendrickson Larry L · Chester, MTN9108GLeder John A · Marble, NCN9108MHorinek Dave L · Goodland, KSN9108URegistration Pending · Studio City, CARegistration pendingN9108XDighans Michael J · Peerless, MTN9109ADra Classic Aircraft LLC · Gravette, ARN9109GVess David G · Gaffney, SCN9109HJunior Coal Contracting Inc · Philipsburg, PAN9109UBrotherson Brian C · Independence, KYN9109XUplift Aviation LLC · Dover, DEN910PFCertified Aviation LLC · Morristown, NJN910TWMultnomah County Sheriffs Office · Portland, ORN9110ASmith Sidney R · Rllng Hls Est, CAN9110HSierra Aero LLC · Truckee, CAN9110XCoffman Ryan S · Marysville, WAN91116Adventure Airways Inc · Homer, AKN9111MSierra Air LLC · Willow, AKN9111UKingdom Air Corps Inc · Sutton, AKN91121Central Illinois Aviators Inc · Galesburg, ILN9112BFosgate Helen Hines · Bogart, GAN9112CCk Jet LLC · Hillsboro, MON9112GPomeroy Vincent Lee · Anchorage, AKN9112MJlck LLC · Jordan, NYN9112UOstrander William P · Millerton, PAN9112XSorenson Chad · Soldotna, AKN9113BBrown David L · Spring City, TNN9113MGospel Ministries International Inc · Collegedale, TNN9114AHayes Sean M · Kodiak, AKN9114HRohwer Michael G Trustee · Tucson, AZN9114UMarek John M · Tucson, AZN9114XDk1 Aviation LLC · Fayetteville, NCN9114ZLarson Richard W · Sioux Falls, SDN91152Dt Pralle Enterprise Inc · Hampton, IAN91156Scarlett Ryan Jay · Sparks, NVN91157Garza Aircraft Inc · Harlingen, TXN9115BParker Justin S · Elko, NVN9115THigginbothan Stewart C · Woodbine, GAN9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeN91162Kelley Patrick J · Catawba, NCN9116BS Dacy Enterprises Inc · Harvard, ILN9116GJones Brian E · Painted Post, NYFirst renewal noticeN9116XTaylor Aviation Inc · Fort Benton, MT
Back to AD 87-20-03 R2