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.
N4977JJad Corp · Saint Cloud, MNN4977LApple Tree Aviation LLC · Gibsonia, PAN4977SMatheaus Michael · Sequin, TXN4977UBaker Bryan D · Anderson, CAN4977YQuality Aviation Inc · Marana, AZN4978CRwr Air Inc · Tok, AKN4978DCanterbury James A · Dixon, ILN4978FLabahn Ty L · Sherwood, ORN4978GJin Jin Aviation LLC · Anchorage, AKN4978TRoth Robert A · Pacific Palisades, CAN4978UKempf Rodney G · Eugene, ORN4978VGeorgeson Troy D · Sheyenne, NDN4979ARothacker Aviation LLC · Chester Springs, PAN4979DTrissell Flying Service Inc · Clarksville, TXN4979ESmith Corey C · Campton, NHN4979SDunn James J · San Ramon, CAN4979VRobertson Roy E · Marion, IAN497ABedell William F H · Church Hill, MDN497BWSwartz Taylor A · Fayetteville, NCN497DSDelaware State University · Dover, DEN497EBFl Scapes Inc · Panama City Beach, FLN497ERPlane Three Ltd · Wilmington, DEN497FLRiggin Flight Service Inc · Madison, SDN497JSLindsey Steven W · Superior, CON497LAPiper 3 LLC · Chestnut Ridge, NYN497LTRonneberg Dave H · Santa Monica, CAN497SJFxe Flightcenter Corp · Fort Lauderdale, FLN497SUSouthern Utah University · Cedar City, UTN497TBennett Howard M · Tullahoma, TNN497TCPinnacle Aviation Services Inc · Encinitas, CAN49809Anderson Erik G · Deerfield Beach, FLN4980PLewis Clinton A · Antlers, OKN4980SGrenie Arles A · Richland Center, WIN4980TAdams Aviation Services Inc Trustee · Wilmington, DEN4980UUniveristy Of Oklahoma · Norman, OKN4980ZElliott Charles · Rock Spring, GAN4981ALeseman Kelly · Anchorage, AKN4981CWatson Michael · Dalhart, TXN4981D23s Flyers LLC · Seeley Lake, MTN4981EHendry Robert L · Lysite, WYN4981GGillespie John · Austin, TXN4981KCuriel Gabriel · Oakley, CAN4981LBasinger Robert C · Freedom, PAN4981PTri State Aero Inc · Martinsburg, WVN4981SLacallle Darren M · Dover, TNN4981VWasatch Industries LLC · Ogden, UTN4982DWeaver Dale · Macon, MSN4982EDevrnja Aero LLC · Knoxville, TNN4982NReirdon Michael Shawn · El Cajon, CAN4983FSkyventure Avaition LLC · Battle Creek, MI
Back to AD 2007-04-19 R1