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.
N341TBWil Aviate LLC · Merced, CAN341TSSecond Delaware Corp · Moorestown, NJN341TVWild Hare Enterprises LLC · Valparaiso, INN341UMedic Choppers LLC · Springdale, ARN341VHYachtphoto Helicopter LLC · Rehoboth Beach, DEN341VTBelmont Leasing LLC · Gig Harbor, WAN341ZMendoza Refugio · Fresno, CAN34202Srs Aurora LLC · Saint Germain, WIN34206Jason Air Inc · Arlington, TNN34209Friesen Chevrolet Inc · Sutton, NEN3420MMoview Aviation LLC · Mountain View, MON3420NKurth Larry A · Williston, FLN3420PKeyuravong Pisonth · Anchorage, AKN3420QBalladares Charles V · Mandeville, LAN3420RBietz Jason L · Tripp, SDN3420WBuffington Brian C · Gillsville, GAN3420XBurns Kevin D · Decatur, TXN3421EWisconsin Aviation Inc · Watertown, WIN3421PLeever William L Trustee · Medford, ORN3421USchuster Timothy A · Carrington, NDN3421XAltitude Aviation Servieces LLC · Mountain Home, IDN3421YMarshall Air LLC · Paso Robles, CAN3422Hergenrather Michael · Spring, TXN34223Strother Brenda J · Kenai, AKN34225Dexter Paul J · Orange, MAN34227Neiser David R · Napavine, WAN34228Thomas Andrew J · Brownsburg, INN34229Winchester Creek Aviation LLC · Waynesville, NCN3422LAwsm Inc · Grand Canyon, AZN3422SLanders James F Jr · Mesa, AZN3422TMangon Ronald A · Petaluma, CAN3422UK & M Aircraft LLC · Granbury, TXN3422YGumley Andrew J · Wasilla, AKN34231Anderson Roger Q · Manassas, VAN34232Nowacki James R · Brighton, MIN34233Stimpson Shawn S · Blackfoot, IDN34235Nefc Inc · North Andover, MAN3423SSchroeder Matt T · Riverside, CAN3423TCardinal Aviation LLC · Springdale, ARN34241Lewis Mark · Ellisville, MON34242Cherokee Pilots LLC · Royersford, PAN34244Eliel F John · Sequim, WAN34248Lucia Arthur H · Blacksburg, VAN3424CHarris Wayne H · Altamont, TNN3424RMulder Field Inc · Ivanhoe, MNN3424SPickering Heavy Hauling · Fort Lupton, CON3424TWiggains David · Canyon, TXN3424WHobaugh Auto Parts Inc · Karns City, PAN3424XCarroll Ronald M · Locust Grove, GAN3424ZSemon Sheldon W · Galt, CA
Back to AD 2007-04-19 R1