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.
N5582YFliege Thomas D · Peoria, ILN55830Rudd Clark David · Sheboygan Falls, WIN55837Mcqueen Bill · Turlock, CAN55838Hintenlang David · Archer, FLN55839David Gill · Marietta, GAN5583DHanks Dustin Maxwell · Milton, FLN5583FAiken Pilot Training LLC · Johnston, SCN5583J5150 Ventures LLC · Effingham, ILN55840Walko Michael E · Scotch Plains, NJN55842Ansboro James C · Goshen, NYN55844Cozby Charles L · Wellsboro, PAN5584DBenson Robert W III · Wichita Falls, TXN5584FGuiliano Anthony · Tobyhanna, PAN5584JDelano James B · Laverne, CAN5584PPinnell Roger D · Shell Knob, MON5584QHurst Jonathan T · Seekonk, MAN5584WDill Mark B · Amarillo, TXN55852Ingold Terry L · Albemarle, NCN55855Caspersen Lars · Bloomsburg, PAN5585FSouth Texas Air Force LLC · Mission, TXN5585JPhb Aviation Inc · Melbourne Beach, FLN5585KMacias Aviation LLC · Canadian, TXN5585PBas Part Sales LLC · Greeley, CON5585QCoxwell James · Midlothian, TXN5585WFoss Jason Steven · Cokato, MNN5585YBlacklock Beech Boys LLC · Langlois, ORN5586DOh Joseph K · Anaheim, CAN5586USoisson Douglas M · Barnesville, GAN55870Legacy Aviation LLC · Tea, SDN55871Van Wagner Aerial Media LLC · Hollywood, FLN55877N A Corp · Scappoose, ORN55879Buchholtz Tony E · Greenville, OHN55880Wings Up LLC · Saint Augustine, FLN55881Phoenix Kingdom LLC · Washington, DCN55884Mcgee Daniel J · Indianola, IAN55885Massa Paul G · Windsor Locks, CTN55888Wild Horse Aviation LLC · Tabor City, NCN5588FRckr Aviation LLC · Chehalis, WAN5588PNorth Town Comanche LLC · North Las Vegas, NVN5588UMontgomery Richard E · Omaha, NEN5588WBartz Nicole · Cleveland, MON55890S & L Sports LLC · New Hampton, IAN55899Aerospace Trust Management LLC Trustee · Wilmington, DEN5589DForrester Dale E · Scotland, PAN5589FTjl Aviation LLC · Atlanta, GAN5589PEggers Cindy S · Winnemucca, NVN5589UGq Aviation LLC · Cherry Hill, NJN558AZHess Michael R · Alexandria, VAFirst renewal noticeN558BTKeesling Roger L · Starkville, MSN558CBFrancis Scott P · Montclair, VA
Back to AD 2007-04-19 R1