AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-R1')
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-10-06-R1')
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-10-06-R1') 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-10-06-R1') 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.
N8863WPratt William D · Cashmere, WAN8864DMarsteller Paul A · Tallulah Falls, GAN8864VAnthony Baruth · Saint Joseph, MON8864YMiller Donald W · Harrisonburg, VAN8865PBrown Travis E · Leicester, NCN8866FReynolds Darryl G · Wills Point, TXN8866NYu Hermon Lemuel C · Mays Landing, NJN8866WPalmer Todd J · Sherrills Ford, NCN8866YCarson Ryan P · Albuquerque, NMN8867NMulloy Dennis · Indian Mound, TNN8867PAnderson Keith C · Puyallup, WAN8867WPayne Jason S · Overgaard, AZN8867YPiper Thirty Nine LLC · Glasgow, MTN8868JGannon Robert M · Hamburg, NYN8868PBurrough Haus Properties LLC · San Marcos, TXN8868VWard Steven E · Wilbur, WAN8868WBolton Barbara A · Alameda, CAN8869JRoot Roger T · Moscow, IDN8869NCarland Ralph B · Altoona, PAN8869WA&O Properties LLC · Harlan, IAN8869YCome Fly Away LLC · Waterloo, ILN886ACAir Ben Aviator Inc · Fort Pierce, FLN886ATDot Aviation LLC · Wilmington, DEN886BNairn Bryan D · Edgewood, WAN886ECUp And Up Aviation LLC · Magnolia, TXN886JBRegistered aircraftN886JHJpj Aviation Holdings LLC · Wilmington, DEN886PBarrons Aviation Services LLC · Henderson, NVN886RASmith Daryl N · Coventry, CTN886RVBazazan Mehrdad D · Fredericksburg, VAN886SACumbass David Shane · Douglas, GAN886SBWhitney Matt Gene · Watertown, SDN886THMock Joseph R · Huntsville, TXN886TVNault Thomas R · Mojave, CAN886ZJohn Galt LLC · Fairbanks, AKN8870DHaumschild Edward E · Marana, AZN8870EGriffin Robert B · Middletown, DEN8870JAsel LLC · North Charleston, SCN8870NRiley Dennis M · Surry, MEN8870VOklahoma Historical Steam Engine Museum Foundation · Oklahoma City, OKN8871DSmith James A · Lyle, WAN8871FGarvey Michael · Leesville, SCN8871JJohnson Richard E · Mulberry, FLN8871NCramer Michael L · Rockville Centre, NYN8871PMq Flights LLC · Missoula, MTN8871WGutierrez Alajandro · Madison, MSN8872DJohnson Robert M · Ada, MNN8872FCameron William Douglas Jr · Lexington, VAN8872GN8872g Holdings LLC · Nashville, TNN8872JPriority Aviation LLC · Lewes, DE
Back to AD 87-10-06 R1