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.
N78799Aerolanding LLC · Enterprise, ALN7879GComposite Systems Inc · Lake Worth, FLN7879PKeenan Matthew J · Clearwater, FLN7879VRowan James T Jr · Silver City, NMN7879WFlyhome One LLC · Chandler, AZN787ANDixon Richard W · Laytonsville, MDN787ARLeung Ka Hung · Apple Valley, CAN787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VAN787BKAmeri Aircraft Sales And Service LLC · Champaign, ILN787BRNaron Robert W · Poolville, TXN787CJInternational Air Services Inc Trustee · Carson City, NVN787CPArnett Wallace · Sullivan, INN787DHHodge Stephen E · Tipp City, OHN787DJDgj Tex LLC DBA · Cleburne, TXN787EBStith Michael P · Boiling Springs, SCN787ECSky Safety Inc · San Antonio, TXN787EMHughes David R Trustee · Fort Knox, KYN787FBHot Wings Aviation LLC · Fishers, INN787GWRegent Trust Corp Trustee · Wichita, KSN787HPHolt Gary L · Ventura, CAN787KSWalden Franklin S · Southern Pines, NCN787LHLawyers Real Estate Services LLC · Roswell, NMN787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeN787NDuenas Carlos · Hurricane, UTN787PCLivingtofly1 LLC · Ball Ground, GAN787PDDougherty Paul · Bethel, PAN787PEPhoenix East Aviation LLC · Daytona Beach, FLN787PMJacobs Philip · Dickson, TNN787RGCareer Aviation Company Inc · Wilmington, DEN787RHRushing Christian W · Savannah, GAN787RKEpitrop Foundation · Wilmington, DENon-citizen corporation, flight hours not reportedN787RPSilver Fox Aircraft LLC · Queen Creek, AZN787RSJjd Holdings LLC · Fort Madison, IAN787RWJw Venture Aviation LLC · Concord, NCN787SDDornberger Eric A · Aurora, CON787SPSierra Tango Ventures LLC · Monte Sereno, CAN787STCitabria N787st LLC · Reno, NVN787TKennedy Thomas M · Long Beach, CAN787TBWoods Phillip A · Cimarron, KSN787TFAir Fleet Holdings LLC · Missoula, MTN787TJTate John D · Roseville, CAN787TKIal Corp · Lewes, DEN787WAnequim LLC · Omaha, NEN787WTSemper Supra Air LLC · Ashland City, TNN78804Whitt James M · Meadowview, VAN78805Fugleberg Richard H · Mayville, NDN78808Ginter Michael J · Oakland, MDN7880GGhegan John · Wilmer, ALN7880WSefinas Avir LLC · Brooklyn, NYN7881GSmith John T · Greenfield, IN
Back to AD 87-10-06 R1