AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N367KRYance International LLC · Mobile, ALN367PTHalcomb Robby · Burleson, TXN367TMTm Ventures LLC · Missoula, MTN368CDSavfar Aviation Inc · Wilmington, DEN368DMNosrati David · Beverly Hills, CAN368FDOakes Farms Food & Distribution Services LLC · Naples, FLN369CHLiberty Leasing Ix LLC · Melbourne, FLN369JDVitale Baxter 2 Llp · Baxter, MNN369PCPine Holdings LLC · Broken Bow, OKN369SESkyfusion II LLC · Atlanta, GAN369SFFlying Pig Express II LLC · Bucyrus, OHN369ZDZelta Air LLC · Newark, DEN36BXCirrus Design Corp · Duluth, MNN36GWSky Whiddon Inc · Fort Lauderdale, FLN36MRCook Canyon (Gp) LLC · Dallas, TXN370GAir Land Ventures LLC · Highland Park, ILN370JGGuideair LLC · Eden Prairie, MNN371CDEicholz Robert Trustee · Palm Springs, CAN371ECNext1sr LLC · Dayton, OHN371PMElias Miguel A · Kenner, LAN372LFShoemaker William · Manns Choice, PAN373BBSchackel Shacks LLC · Durango, CON373CDKnight Douglas G · Bend, ORN373DSRegistered aircraftN373ERStx Aviation LLC · Fresno, CAN373MCKenmore Crew Leasing Inc Trustee · Bellingham, WAN373PSEngineered Propulsion Systems Inc · New Richmond, WIN373SRSummer Dog LLC · Greenwich, CTN3747TAir Force One LLC · Coral Springs, FLN374CDN374cd LLC · Goffstown, NHN374RLDeep Blue Spring LLC · Doral, FLN374WHLr Freedom Air LLC · Tallahassee, FLN375BMBlotsky Jim · Fargo, NDN375CDAtlantic Marine Construction Co Inc · Virginia Beach, VAN375DBEight Aviation LLC · Greenwood Village, CON375MTVan Bortel Aircraft Inc · Arlington, TXN375NDInsuring That Pigs Can Fly LLC · Tyrone, GAN375RRRegistered aircraftN375THRbm Records And Promotion LLC · Clinton, OHN375TT4two9 Aviation LLC · Princeton, FLN376BCKunz Paul C · Midway, UTN376CDWestern Chancellor LLC · Fort Worth, TXN377ALKairis Perry A · High Point, NCN377BCMelcor Aviation LLC · Hopkinton, MAN377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN377JJThree L Aviation LLC · Victor, NYN377MRMaquinarias Repuestos Inc · Miami, FLN377TXFauber Dan · Granbury, TXN378CTamavo Inc · Baltic, SDN378GLReel Trip LLC · Knightdale, NC
Back to AD 2007-24-13