AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3158RHelms Stephen G · Anchorage, AKN3158SBr Aviation LLC · Lewes, DEN3158XJims Helicopter LLC · Waupun, WIN31592Pharr Jonas · Benton, LAN31593N31593 LLC · Key West, FLN31594Kjeldgaard James K · Fremont, NEN3159EDinaland Aviation · Vernal, UTN3159FYarbrough Chad · Bloomingdale, GAN3159RSdmg Signs LLC · Las Vegas, NVN3159TLown Alfred L · Elkhorn, NEN3159ZPepin Daniel J · King Salmon, AKN315ABColabianchi Bob J · Fountain Hills, AZN315ACDuewall Danny · Midland, TXN315AGAlpert Adam L · Delray Beach, FLN315ATHess John G · Fayetteville, GAN315BCasteel Robert C DBA · Elk Grove, CAN315BPKing Logistics LLC · Ridgeland, MSN315CDFranklin Clinton · Edmond, OKN315DBBooker Daniel R · Newaygo, MIN315DCJohnstone Inc · Wilsonville, ORN315DFDilger Alfred V · Bakersfield, CAN315DMSpartan Education LLC · Tulsa, OKN315DPChevalier Richard J · Columbus, NMN315EFMatherne Aviation · Houma, LAN315GVancleve Cole · Cotulla, TXN315GEHull Brian D · Grand Forks, NDN315HAschbrenner Matthew D · Statesville, NCN315JPerri James D · Chelan, WAN315JFFuller Jon A · Goliad, TXN315JKKessler James H · Rio Rancho, NMN315JPGlasgow James · Stamping Ground, KYN315JRStarkweather James · Southwest Ranches, FLN315LAZalen LLC · Mercer Island, WAN315MAWaterwings Seaplanes LLC · Hoover, ALN315MEBlue Horizons Flying Club Inc · Perrysburg, OHN315MPMunn Paul D · Harrisburg, NCN315MTFly Mt Llp · Charlo, MTN315NFOconnor Randy B · North Port, FLN315SSnk Properties LLC · Spring Lake, MIN315SBKusler Bradley D · Lincoln, NEN315SFSnohomish Flying Service Inc · Snohomish, WAN315SGBuell Travis W · Harper, TXFirst renewal noticeN315SKOklahoma Aviation LLC · Bethany, OKN315SMLe Petit Oiseau LLC · Englewood, CON315SQDe La Haye Ludo · Edgewood, TXN315TMSteadman Tony L · Arlington, TXN315TPN315tp LLC · Stuart, FLN315VRegistered aircraftN315WADemeyer Scott M · Olympia, WAN315YHancock Phil R · Live Oak, FL
Back to AD 2007-04-19 R1