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.
N4532SElite Aviation Partners LLC · Blacklick, OHN4532UAtlas Builders LLC · Valdosta, GAN4532WAbernathy Aviation LLC · Morristown, TNN4532XMarrs Daniel J · Red Wing, MNN4533AMount David B · Fairbanks, AKN4533BHastie William B · Anchorage, AKN4533FHall Jonathan D · Allison Park, PAN4533JStevens Investment Group LLC · Elsie, MIN4533PFoltz Jeffrey W · Richmond, TXN4533QBritton David L · Franklin, OHN4533SBolanos Nilson J · Fairview, NJN45343Bobbish Charles G · Reston, VAN45344Adventure North Flying Service LLC · Baudette, MNN4534BHornung Chet R · Nikiski, AKN4534DOliver Larry C · Citrus Heights, CAN4534E34 Echo Group · Spring Branch, TXN4534FSmith Peter A · Gunnison, CON4534JCartaya Lazaro C · Miami, FLN4534LBottem Lee T · Broken Arrow, OKN4534MFowler Bruce Jr · Cedar Park, TXN4534RDuwelius Charlotte Sue DBA · Hermiston, ORN4534SMarmon Robert A · Merion Station, PAN4534TSunrise Aviation Inc · Ormond Beach, FLN4534VSammons Ryne William · Bargersville, INN4534X4534xray Flyers Ltd · Lima, OHN4535DFrancis Mark D · Holden Beach, NCN4535FRohde Allen G · Eagle River, AKN4535JMooney Executive Partnership · Kent, WAN4535LCratz33 LLC · Cincinnati, OHN4535TCrews Joseph G · Cleveland, MSN4535VSanders Aviation LLC · Boerne, TXN45362Morrow Rodney T · Yorktown, INN4536BHolsten Guy V · Mineral, VAN4536JSale Reported · Merrill, WISale reportedN4536KGowharrizi Ardeshir G · Los Angeles, CAN4536LFlorence Glen A · Shelby Township, MIN4536PPastuszenski Wayne · Austin, TXN4536RRoesler Robert D · Gordonsville, VAN4536TSherrod Roger F · Orlando, FLN4536VReese Thomas R · Marathon, FLN4536WAlger Michael · Umatilla, FLN4537GNovember Alpha LLC · Dover, DEN4537JTurkey Holler LLC · Knox City, TXN4537MBullet Construction LLC · Roswell, NMN4537NWeigand Robert A · Arcadia, FLN4537QInstant Security Service Inc · Wilmington, DEN4537TRussell Brice S · Milton, MAN4537VAir Land And Sea Inc · Brewerton, NYN4538AHughes William L · Fort Worth, TXFirst renewal noticeN4538EGrasshopper Flying Club Inc · Poughkeepsie, NY
Back to AD 2007-04-19 R1