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.
N711WDSeawind Adventures LLC · Reno, NVN711WEMelbourne Flight Training LLC · Melbourne, FLN711WZBaker Matthew · Mesa, AZN711XCFore Shannon Richard · Wasilla, AKN711YAStegmann Scott A · Port Orange, FLN711YCIturriria John M · Kuna, IDFirst renewal noticeN712Oman Lee · Sequim, WAN7120DWeiss James R · Westlake, OHN7120GSky Hook Inc · Red Wing, MNN7120LTschirhart Larry S · San Antonio, TXN7120QClodfelter Terry Lynn · Norwood, NCN7120VOpulent Investments LLC · Mandan, NDN7120YRoyal Ryan M · Lincoln, NEN7121DBohrman Robert C · New Berlin, WIN7121PLecren Douglas · Wasilla, AKN7121YUhlemeyer William A · Alvin, TXN7121ZQuality Aviation Inc · Marana, AZN7122AContinental Helicopters Inc · Sheffield, TXN7122BCgu Aviation LLC · Naples, FLN7122EChristiansen Aviation LLC · Wilmington, DEN7122GBirmingham Flight Center LLC · Birmingham, ALN7122JCarrizales Chad A · Jacksonville, ARN7122RSimmons Heating And Air Conditioning LLC · Summerville, SCN7122VProvance Brent L · Granbury, TXN7122YSutton Jack M · Jesup, GAN7123GJet & Rotor Aviation LLC · Sacramento, CAN7123PMclenaghan Alvain N · Phoenix, AZN7123UMatherly Frank · Greenbrier, TNN7123WHarvick Wayne P II · Kenmore, WAN7124LTriad Management Group LLC · Papillion, NEN7124PTalley John T · Clifton, TXFirst renewal noticeN7124QVy Aviation LLC · Gentry, ARN7124RNewsome Thomas D · Canal Winchester, OHN7124UGoss Brendan · Shady Shores, TXN7124VHunter Cameron Brooks · Keller, TXN7124WTuchols John E · Lockport, NYN7125DWarrior Creek Adventures LLC · Moultrie, GAN7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeN7125LCulbertson Lloyd K · Phillipsburg, KSN7125PHernandez Jimmy Lee · Lamesa, TXN7125QPiedmont Flight Inc · Winston Salem, NCN7125UTakacs Robert S · Oxford, CTN7125VSutphen James A · Henderson, TXN7125WRavelli Sidney · Salem, OHN71266Kuhtenia David G · Galena, OHN7126DKintner Daniel S · Conyers, GAN7126GHenry Rolla G Jr · Saint Charles, MON7126RLeonard Justin P · Charleston, SCN7127BGeorge William A · Denton, TXN7127RGreen William A · Memphis, TN
Back to AD 87-10-06 R1