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.
N8986SSchneider Jackson L · Florissant, MON8986UJmt Aviation LLC · Bel Air, MDN8986VAirline Transport Professionals Corp Of USA · Wilmington, DEN89877Hillsboro Aero Academy LLC · Hillsboro, ORN89878Corwin Shawn M · Tucson, AZN8987BHoover Rowdy L · Owasso, OKN8987TPeavy Magnus Delacy IV · Crawfordville, FLN8987VPiper Capital Growth Fund LLC · Scottsdale, AZN89881Fulton Gene · Spartanburg, SCN89887Pea-Wayman Flight LLC · Daytona Beach, FLN8988UQuestair LLC · Madison, MSN8988VWahle Daniel C · Missoula, MTN8989MSkymaster Mods & Parts LLC · Castalian Springs, TNN898AHAerospace Asset Holdings LLC · Wilmington, DEN898BPetropulos James J · Juneau, AKN898BHPompa Oliver · Tuscon, AZN898HCSmith Andy · Fitzgerald, GAN898SWHealy Ronald L · Anchorage, AKN898TMKingsley Kaland W · Miller, MON8990BSortomme Jeffrey P · Sacramento, CAN8990TPoulter Michael D · San Angelo, TXN8992GKing William · Tallulah, LAN8992UCole Lawrence E · Willow Street, PAN8992VFreeze Otis C · Frankston, TXN89933Sunrise Aviation Inc · Ormond Beach, FLN89934Sunrise Aviation Inc · Ormond Beach, FLN8993SRopp Dale Arden · Bemidji, MNN8993TCoughran Aviation LLC · Rio Vista, CAN8993VBmg Aviation Leasing LLC · Bloomington, INN8993WWagner Mitchell · Northlake, TXN8993XEvans David J · Parker, CON8994GRussmann Nicholas S · Merit, TXN8994SMorel Charles Paul IV · Morgan Hill, CAN8994TRollings Paul W · Anderson, SCN8994UWahlberg Randy A · Pearland, TXN8995BSommerfeld David A · Assaria, KSN8995SLonneman Robert P · Edgewood, KYN8995UKelley Aircraft LLC · Weyers Cave, VAN8995XHowards Hangar LLC · Peachtree City, GAN89963Wardall Wesley David · Ione, CAN8996BGartrell Kirk W · Amarillo, TXN8996SSoaring Thunderbirds Inc · Canton, OHN8996TWedemeyer Bonnie J · Cheyenne, WYN8996VBaumgartner Scot W · Colby, WIN8996XRobertson Timothy A · Lewistown, MTN8997SRed Barn Ag & Home Inc · Westville, OKN8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEN89980Ace Aircraft Leasing Inc · Nazareth, PAN8998BValles Rick James · Albuquerque, NMN8998THayhurst Jack R · League City, TX
Back to AD 87-20-03 R2