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.
N6548JInspire Aviation LLC · Magnolia, TXN6548PPettus Gary A · Fort Mill, SCN6548VMaxwell Frank R · Fairbanks, AKN6548ZKingsley Kiman J · Miller, MON6549AGregory P Cook LLC · Spokane, WAN6549DBbjs Investments LLC · Waukesha, WIN6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeN6549ZRivers Larry R · Talkeetna, AKN654ALMoore Howard · Camden, TNN654BCCobb Charles J · Fallbrook, CAN654CRLinde Rodney C · Weatherford, TXN654EZN654ez LLC · Oyster Bay, NYN654FKimmel John · Milwaukie, ORN654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDN654FTFlorida Institute Of Technology Inc · Melbourne, FLN654JFFreele James E · Rio Rancho, NMN654JWWilson Jared D · Midway, UTN654MRlw Wholesale LLC · Myrtle Beach, SCN654MDProfessional Storage Inc · Hobe Sound, FLN654NSElks Stephen A · Mountain City, TNN654PJPajak Paul J · Groveland, FLN654PTAnerv6a LLC · Minneapolis, MNN654PVHouston Traville S · Granbury, TXN654RTKonrad Melvin J · Cumming, IAN654RVVan Hoff Eric J · Gunter, TXN654SHHutcherson David R · Gretna, VAN654SPJm Air Holdings LLC · Stevensburg, VAN654WMMillar Rick A · Anchorage, AKN654YRVet Air LLC · San Juan, PRN654ZZarmada LLC · Issaquah, WAN65503Bentz Andreas · Falls Church, VAN65507Cora & Associates LLC · Norcross, GAN6550JJans Stanley E · Dakota City, NEN6550PLux Kevin C · Vancouver, WAN6550UGeorge Ladelle L · Ashley, NDN65512Wiebe Van Michael · Filer, IDN65514Vogt Gregory A · Broken Arrow, OKN65515Peterson Darren · Janesville, WIN65516J-Airco LLC · Nashville, TNN65518Tk Equipment LLC · Brownsburg, INN6551LParker Kerry · Hobbs, NMN6551PWsv Aero Inc · Wilmington, DEN6551UAuker Donald · Lebanon, PAN6551WThull Stanley B · Freeport, MNN65525Sinha Nanda K · Benicia, CAN65528Jacks Charles D · Crowley, LAN6552FAir Planes LLC · Soddy Daisy, TNN6552JCherokee Flyers Inc · Phoenixville, PAN6552PSyc Holdings LLC · Missoula, MTN6552UGoldstein Meyer · Underwood, WA
Back to AD 87-10-06 R1