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.
N6214JSale Reported · Mikado, MISale reportedN6215XWeber Donald E · Saint David, AZN6216JThibeault Barbara C Horne · Eagan, MNN6216NHitt Kenneth A · Driftwood, TXN6216PDuvall James Grafton III · Silver Springs, NVN6216RRegistered aircraftN6216XCentral Alabama Soaring Association · Birmingham, ALN6217CButler Donald D · Petersburg, PAN6217HWalker Robert J · Manvel, TXN6217JNathaniel Greene Dev Corp · Stanardsville, VAFirst renewal noticeN6217PYork Robert H · Zephyr Cove, NVN6218JNelson Jeffery M · Eagle River, AKN6218PSmith Ron E · Goodlettsville, TNN6218QOzarks Auto Show Inc · Hollister, MON6218UEkstrum Eric · Mound House, NVN6218ZLorenzo Ag Air Inc DBA · Lorenzo, TXN6219YTab Associates Inc DBA · Port Saint Lucie, FLN621ACFlorida Institute Of Technology Inc · Melbourne, FLN621BFBoldflight LLC · Danville, INN621BSStauter Mike D · Idabel, OKN621CASair LLC · Natchitoches, LAN621CLN621cl LLC · Overland Park, KSN621DAdams Consulting & Programming Inc · Quincy, ILN621DCResource Extension LLC · Jupiter, FLN621DHPic Aviation LLC · Fort Valley, GAN621EHofstetter Michael T · Saint James, MON621FJ8th Dimension Enterprises LLC · Aurora, ORN621FLKiani Behdad · Elk Grove, CAN621FTFlorida Institute Of Technology · Melbourne, FLN621GLOverwatch Tools Inc · Chesapeake, VAN621HDyer John T · Whispering Pines, NCN621HSBlue Skies Flying Services Inc · Lake In The Hills, ILN621KHMoody Aviation Management LLC · Forest, VAN621LPM2 Equipment LLC · Lubbock, TXN621LTWood Austin F · Seattle, WAN621MSAyagon Cecilia · Sequim, WAN621NDUnd Aerospace Foundation · Grand Forks, NDN621PWSkyten Flying Club Inc · Orefield, PAN621RMLouie Garrick S · Reno, NVN621TCsa Aircraft Leasing LLC · Salt Lake City, UTN621TGSchmotzer Donald S · Ladson, SCN621TKSheeptick LLC · Conrad, MTN621VBingham Lane M · Marble Falls, TXN622Chambliss Aerobatics LLC · Chandler, AZN62209Christiansen Aviation LLC · Wilmington, DEN6220UBarnes Dennis W · Saint Joseph, MON6220WPuls Timothy W · Plainfield, ILN6221JReese Joel Scott · New Smyrna Beach, FLN6221PLicata Paul Z · Mexico, MON6221UScott Terry · Panama City, FL
Back to AD 87-10-06 R1