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.
N7726DClaypool Bruce W · Bethel, AKN7726POcallaghan David · Bonney Lake, WAN7726TWildwood Aerospace LLC · Cabot, ARN7726WJrw Flight LLC · Huntsville, MON7727GSkyhawk Air LLC · Brunswick, GAN7727PTaylor Aviation LLC · Corning, ARN7727WAukee Isaac J · Ironwood, MIN7728GTakeflight LLC · Spanish Fork, UTN7728JClear Skies Leasing LLC · Okemos, MIN7728KPolkowske Leroy A · La Jara, CON7728NP-Factor Aviation LLC · Hoover, ALN7728WSchrage Kevin J · Trevor, WIN7729CPeterman Keith · Taylorsville, KYN7729GValiair Lc Trustee · Casper, WYN7729PPendergast Gary · Clermont, FLN7729VNew England Soaring Tug LLC · Perkinsville, VTN7729YFogle Neil · Conroe, TXN772BDSmith Joy I · Mccall, IDN772CAChristiansen Aviation LLC · Wilmington, DEN772DLClik Services LLC · Forestdale, MAN772DMAmerican Aerial Imaging LLC · Fort Wayne, INN772DSCharleston Aviation Inc · Charleston, ILN772EMelvin Daniel · Larkspur, CAN772EZSkylake Adventures LLC · Geneva, OHN772FTJazz Air LLC · Melbourne, FLN772JNBialek Joe · New Smyrna Beach, FLN772JTTinley Jim · Sandersville, GAN772KMGriffith Keith T · The Villages, FLN772LRMorris Charles R · Nampa, IDN772MESlow Walkin Barnstormers LLC · Frostproof, FLN772MSSchmidt Barnet M · Oradell, NJN772NDUniversity Of North Dakota · Grand Forks, NDN772RAKehmeyer Aviation LLC · Bronson, MIN772SDWallace Robert L II · Anderson, SCN772SFAcademy Aeronautique LLC · Mission Viejo, CAN772SHLawrence John · Anderson, CAN772TWBugden Michael S · Newnan, GAN772VBSkybone Airline Academy Inc · Vero Beach, FLN772WSSouthwest Technology Center School District No. 27 · Altus, OKN772ZZCirri Joseph A · Deming, NMN7730CBug'Z Land Clearing LLC · Pensacola, FLN7730PCox Paul G · Bryce, UTN7730WSuh Y H Charles · Rowland Heights, CAN7730ZRubbert Jan · Upham, NDN77319Dahlkamp Ethan R · San Diego, CAN7731NThompson Randy L · Anderson, CAN7731PSchwehm Karl E · Roach, MON7732PMckenney Michael P · Spring, TXN7732WWoodhead James R · Charleston, SCN7732YPurcell David S · Chandler, AZ
Back to AD 87-10-06 R1