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.
N6908UPaul Michael · Fort Worth, TXN6908VForoozesh Paymon Michael · Olalla, WAN6909BKaufmann Arnold L · Davenport, IAN6909NDevore John A C · Marion, OHN6909PWest Texas Weather Modification Association · San Angelo, TXN6909QHuston Lee E · Graham, WAN6909UVandivort Austin J · Strawberry Plains, TNN690ABKirkland Klayton E · College Station, TXN690BLincwings Society LLC · Austin, TXN690HAAims Community College · Greeley, CON690JTAviationmt LLC · Kalispell, MTN690LHChristiansen Aviation LLC · Wilmington, DEN690PMMiddlefield Farm And Garden Co · Middlefield, OHN690RGRegistration Pending · Gurabo, PRRegistration pendingN690RRCentral Airlines Inc · Leawood, KSN690SHCorriher Mark B · Mocksville, NCN690VBruegger Traylin T · Lance Creek, WYN690ZKalisz John B · Newhall, CAN6910DWood Robert A · Sheboygan, WIN6910JPlane Nonsense Inc · Middletown, DEN6910NThornton Michael W · Clinton, NCN6910PBlue Skies Aviation LLC · Algona, IAN6910UEmbrey Quentin S · Beaver Dam, KYN6910VLehman Aubrey M · Temple, TXN6911HHarbour Aviation LLC · Weatherford, TXN6911JJacksonville Airport Authority · Jacksonville, ILN6911PMalo Blake Ridgway Trustee · Portland, ORN6911QKirby Richard L Trustee · Albuquerque, NMN6911YDelaware Aircraft Trust LLC Trustee · New Castle, DEN6912JHammond Brian M · Gresham, ORN6912PAnzaldua Johnny J · Midland, TXFirst renewal noticeN6912WTop Flight Aviation Snh LLC · Savannah, TNN6913ANorthwoods Air LLC · Orono, MEN6913BKeyt Jeffrey D · New Providence, NJN6913JFlight Time LLC · Conover, NCN6913NJennings William A · North Little Rock, ARN6913RAirplane And Drone Flight Instruction LLC · Orlando, FLN6913SRural Development Corp 1 · Steamboat, CON6913UShaw Brian D · Meadville, PAN6913WAden James D · Gothenburg, NEN6914AFlyn 6914 Alpha LLC · Oak Island, NCN6914BLark Bradley J · Enoch, UTN6914JKreppel Frederick W · Wayne, PAN6914ULiskey John W · Kelseyville, CAN6914VDuke Terri D · Oakwood, GAN6914WPearson Timothy M · Waterville, OHN6915H2gbs LLC · Wilder, IDN6915NBaker Stewart D · Severna Park, MDN6915QWilson Kenneth G · Peoria, AZN6915TSpier Samuel · Carson City, NV
Back to AD 87-10-06 R1